Forum Discussion
Can't enter 7 digit number.
If I type 1,000,000 into a cell, it displays as 10,000. I can't get it to display 1,000,000. I tried "clear all" and it didn't help. The spreadsheet is not protected. What is going on and how do I fix it?
1 Reply
Select File > Options >Advanced.
If the check box "Automatically enter a decimal point" is ticked, clear it, then click OK.
