cell format

  • Thread starter Thread starter chris
  • Start date Start date
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.
 
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
 
Back
Top