excel changes numbers

[amullin]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC When I enter a number Excel automatically changes it to a decimal. I enter one, it changes it to 0.01. I have specified the cell format to "number", it is not currency or percentage. Very annoying, I have to enter all my numbers as multiple of 100 to get the right number to display.

 

[CyberTaz]

As answered just yesterday & numerous times before:

http://www.officeformac.com/ms/ProductForums/Excel/6389

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC
When I enter a number Excel automatically changes it to a decimal. I enter
one, it changes it to 0.01. I have specified the cell format to "number", it
is not currency or percentage. Very annoying, I have to enter all my numbers
as multiple of 100 to get the right number to display.

For your own benefit it's recommended that you search the group before
posting a question. The odds are you aren't the first to encounter it, and
if that'd the case you'll typically get your answer much more quickly if
your search terms are reasonably accurate... Seconds rather than hours or
possibly days

Regards |:>)
Bob Jones
[MVP] Office:Mac