View original (French)

Move the decimal point to convert (e.g. 3.45 to 34.5)

BlablaAlya -  
Vaucluse Posted messages 27336 Registration date   Status Contributor 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.

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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!
    0