How do i stop automatic decimals after number ex 5280.?

G

Guest

Excel adds a decimal point, even if the number format I use doesn't include a
decimal point. It just doesn't look right to have an integer number like
5280 displayed as 5280. (with a decimal point). Is this a bug in Excel?
 
G

Gord Dibben

If you had a number format like #,##0. you would see this.

Format>Style>Normal>Modify>Number.

Change to the format of your choice then OK your way out.

Note: Styles are a workbook setting.

If all your Excel numbers are taking on this #,##0. format, I would suggest
you go into Windows Regional and Language Options and check/change your
settings there.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Troubleshoot a bug in Excel 1
excel spreadsheets 3
Lotus to Excel Problem 2
Help with Formatting Number as Text 5
Format Number Outlook Merge 1
Omitting the whole number when formatting decimals 11
extract decimal and convert to integer 9
How do I round off a number to 333.00 instead of 332.84? 3

Top