Move the decimal point to convert (e.g. 3.45 to 34.5)
BlablaAlya
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I would like to make a change to several rows and columns in my Excel file,
I have decimal numbers to represent a value in kg and I would like to move the decimal point so that the value is represented in grams.
Thank you for your help.
I would like to make a change to several rows and columns in my Excel file,
I have decimal numbers to represent a value in kg and I would like to move the decimal point so that the value is represented in grams.
Thank you for your help.
1 réponse
Hello
to convert grams to kilograms, you just need to move the decimal point a bit more!
try with:
enter 1000 (or the desired coefficient) in an empty cell
select the range to be processed
right-click / Paste / Paste special and "multiply"
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
to convert grams to kilograms, you just need to move the decimal point a bit more!
try with:
enter 1000 (or the desired coefficient) in an empty cell
select the range to be processed
right-click / Paste / Paste special and "multiply"
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!