Excel Tips: Convert Centimeters into Kilometers in Seconds

Mr. Devotor

In this video, you will learn how to convert Centimeters (CM) into Kilometers (KM) in Microsoft Excel using two simple methods:  ✔️ Direct formula method ✔️ Excel’s CONVERT function  We’ll also create a clean Excel table and show how your CM values automatically turn into KM values. This tutorial is perfect for students, teachers, office users, and anyone working with unit conversions in Excel.  👉 What you will learn:  How to use the formula: =A2/100000  How to use Excel's built-in conversion function: =CONVERT(A2,"cm","km")  How to reverse the calculation (KM to CM)  How to format results properly  If you find this tutorial helpful, don’t forget to LIKE, SHARE & SUBSCRIBE for more Excel tips and tricks!  ✅ Hashtags  #ExcelTutorial #ConvertCMtoKM #ExcelFormula #MicrosoftExcel #ExcelTips #UnitConversion #CMtoKM #ExcelForBeginners #SpreadsheetTips #OfficeTutorial

Transcript

00:00if you are looking for how to convert centimeter to kilometer in excel like this one then keep

00:06watching here you can see that there is a centimeter and i have converted into kilometers

00:12with this formula so how you can do that use the put is equal to use the convert function

00:20bracket open select the cells comma double quote put the cm double quote comma double quote

00:35and for kilometer use km and double quote and close the bracket hit enter and you can see that

00:463 lakh centimeter is equal to 3.01 kilometer and just track the other values here is the results

00:56so you can cross check by you can convert kilometer to centimeter so this time put the formula is equal

01:03to again use the convert function break it open and select the cells comma double quote

01:16and now use kilometer this time and double quote comma double quote hit cm because you are converting

01:26now kilometer to centimeter now double quote and close the bracket hit enter and now you can see

01:35that the values are same and drag the values to the other so all the values are same so this way you can

01:44easily convert centimeter to kilometers in excel or vice versa kilometer to centimeter so if you think you

01:51have learned something new please support my channel thanks for watching

Category

Transcript

Be the first to comment

Recommended