Wednesday 14 October 2015

Excel Tips - Tip 38 (Using Convert Command)


Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.
If ever we want to covert any values in measures , then we can use “CONVERT” Command.

What Does It Do ?
This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimeters.


How to use it ?
''=CONVERT(Amount To Convert , Unit To Convert From , Unit To Convert To)

For examples please check the below images




Bonus Tip : Certain Abbreviation that can be used to use the Command. Please find the attached Images for the Abbreviation.




Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.


If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:


If you have something that you want to share with the group, please write to excelms.tips@gmail.com


Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast


+91-9045773456

No comments:

Post a Comment