Formatting a Cell with a number without a decimal point

A

alanl3

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel If I want to enter a number without a decimal point such as 523 I have to enter it as 523.00 and then set zero decimal places. No matter how I try to format it as 523 it either becomes 5.23, or is truncated to 5.
This only happens on some worksheets and might only occur in one column. What is wrong and how can I correct it?
Thanks in advance.
Alan
 
C

CyberTaz

Excel> Preferences> Edit, clear the box for "Display this number of decimal
places".

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
A

alanl3

Thank you Bob,

It worked perfectly. I didn't know that Preferences>Edit existed.

Alan
 

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

Top