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
 

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

Excel does not accept text format! 0
Inconsistent formatting of section numbers 0
VBA - (re-) Set a Table Style 2
Finding the proper style field and the numbered paragraph value within the style 0
Subtracting time...again 2
Sorting 1
Creating Multi Level list using Header Style 1
Paragraph numbering in Word 1

Top