This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I cannot get a whole number to appear in a cell. The number 1 appears as 0.01 or if I change the decimal points to zero, then the 1 shows as 0. any ideas how I can get the numbering to work correctly please?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
The issue isn't with Formatting, it has to do with a Preference setting.
Go to Excel> Preferences - Edit to clear the check on Display this number of decimal places. You'll have to re-enter any data previously affected.
Answer accepted by question author
I don't run a Mac but try in Editing Options to uncheck "Automatically add a decimal point"
Gord
JS, Thank you.Problem solved. It was a Preferences issue.
Bob. Fantast help, thank you so much. Kind regards. Geoff
What is the cell fiormatted as? Try to change to general.