cell format

C

chris

When I enter a whole number (i.e. - 1, 2) into a cell, the result is a
percentage (i.e. - .01, .02). I have reset the format to number, with no
success.
 
B

Bernard Liengme

Sounds like you have got Fixed Decimals turned on - this lets you type 12345
and get 123.56 (for lazy bookkeepers)
Use Tools | Options; open the Edit tab; uncheck the Fixed Decimal option box
best wished
 
Top