Excel Formula for Kg to Pounds, Mt to Ft, Liter to Gal?

In Worksheet, we can use the formula “=CONVERT (Number, Unit From, Unit To)”.

Examples:

=CONVERT(1000,”g”,”lbm”) <-1 kg to lbs = 2.204622622

=CONVERT(1,”m”,”ft”) <-1 meter to feet = 3.280839895

=CONVERT(1,”mi”,”ft”) <- 1 mile in feet is 5280 units

=CONVERT(1,”gal”,”l”) <- 1 gallon to liter = 3.785411784

=convert(1,’ft’,’m’) <- 1 feet to meters is 0.3048 Units

Thanks to Hossein Satour for suggesting this function name in comments section.

Excel Unit Conversion – Additional References

For more unit names used in this function, refer this page from Microsoft. The same function is used in the Advanced Tab in the above Excel download.

These days, Google itself will do its conversion directly from its search results page. If there is too much of unit conversion needed within your automation, then use the functions explained in this page.

If you have other conversion to be included with this app, leave it in the comments. Provide units & its conversion table that would benefit the readers.

Author: Kumarapush

Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.