00:00learn how to convert centimeters to meters in decimal in excel this quick tutorial shows you
00:06the exact formula step-by-step method and an example table to help you understand the conversion
00:14so how you can do that i have a table over here and you can see that there is the cm and then
00:21meters so for this you need to use the convert formula put the equal sign type convert
00:30bracket open give the reference cell comma double quote and you need to use cm because you are
00:40converting cm to meter so cm is the abbreviation of centimeters double quote and then comma and again
00:51double quote and meters abbreviation stands for m and double quote and close the bracket hit enter
01:02and now drag the fill handle
01:09to see the other values so select all the values and under the home tab you will see that in number
01:18there is a decimal so you need to increase the decimal so you can see that the 100 centimeter
01:26equal to 1 meter and 125 cm equal to 1.25 and similar the figures are cosine so keep in mind that the
01:38100 centimeter is equal to 1 meter so you can use the direct multiplication formula for this you need
01:46to put the equal sign select the cell reference which is the meter and multiply by 100 and hit enter
01:55and you can directly find in this way so i hope you understand you can convert centimeter to meter in
02:03decimal in decimal in excel if you think this video is helpful please support my channel thanks for watching
