00:00If you are having problem to convert meter into kilometers in Excel then this video is perfect for
00:06you and first you need to use the convert function and I have a meters in the column B and there is
00:15a kilometer and in the column C so how you can convert this put the equal sign and use the
00:22convert function open the bracket select the cell reference give the comma and put the double quote
00:31and put the M and stands for meters double quote comma double quote and put KM abbreviation is the
00:46of kilometers double quote and close the bracket hit enter and now use the fill handle to drag the
00:58other values and here you can decrease the decimals so 1000 meters equal to 1 kilometer and simultaneously
01:092000 meters equal to the 2 kilometers so you can also use the division or multiplication formula
01:16and put the equal sign and select the cell reference and multiply by 1000 keep in mind that the
01:27in one kilometer equal to the 1000 meters so hit enter and this is what you can easily drag the
01:37other values so I hope this video helps you to understand how you can convert meters into
01:42kilometers in Excel I'm sure this is pretty simple and easy if you think this video is helpful please
01:47support my channel thanks for watching
Comments