Forum Discussion
Add a whole number to a Cell and it shows the number as a 100th i,e 4 goes to 0,04
When I change a whole number in a Cell of an existing workbook it inputs the number as a 100th i,e if I change 5 to 4 it shows as 0,04 Notes. 1) I'm in Indonesia so the separator for a decimal i...
Select File > Options > Advanced.
Under Editing options, clear the check box 'Automatically insert a decimal point'.
Click OK.
Thank you Hans, this worked perfectly.