Forum Discussion
WHOLEY_GAUCHE
Jun 08, 2022Copper Contributor
Unable to enter account number correctly on current Spreadsheet document
I am attempting to enter this account number (09115111586407) into ANY CELL (since I was unable to insert the number into the specific cell I wanted in my current document for the first time (THIS cu...
Ron_Meyer
Mar 15, 2023Copper Contributor
When I enter a five digit number as text it does it correctly, but when I move to the next cell it reverts to changing 879543 to 8795.43.
HansVogelaar
Mar 15, 2023MVP
On Windows:
Select File > Options > Advanced.
Under 'Editing options', clear the check box 'Automatically insert a decimal point'.
Click OK.
On Mac:
Select Excel menu > Preferences > Edit.
Clear the check box 'Display this number of decimal places'.
Close Preferences.