Forum Discussion
Decimals
I need to input a decimals into a number. EX 1234 have to be 12,34. I have 385000 lines to do this in. Any simpel way?
The difference between the numbers as you show them is a factor of 100. Do you actually wish to change the number or merely its presentation?
If the former, then use the formula
= number / 100
If the result has to be in the original position on the sheet, then copy and paste/values over the source data.
If you wish to change the presentation but leave the values unaltered then the decimal separator can be 'faked' by using an appropriate number format
0\,00