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?
I assume that for 12,34 [sic], comma is the decimal point in your region. That is, it represents 12 + 34/100.
And I believe that you want to enter the numbers without an explicit decimal point, and you ask that Excel inserts the decimal point to the left of the last two digits automagically.
There is an option for that. But how to find and selecxt it varies depending on platform (PC vs Mac) and Excel version.
In my version, I click File > Options > Advanced, then checkmark the option Automatically Insert Decimal Point.
Of course, cells might also need to be formatted to display 2 decimal places.