In Excel, numbers I enter are divided by 100 tho' not % formatted

F

Father Christmas

The cells concerned keep on behaving like this even if I change the cell
formats while the cells are empty from Number to text and back to number. So
if I type 9 in one of these cells, it is stored as 0.09. I can work around by
typing 900 to get a 9, but I don't like doing this and shouldn't have to.
What are Microsoft Excel & I doing wrong?
 
C

Chip Pearson

You have the 'Fixed Decimal' setting turned on. Go to the Tools
menu, choose Options, then the Edit tab. There, uncheck "Fixed
Decimals".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Father Christmas" <Father (e-mail address removed)>
wrote in message
news:[email protected]...
 
K

Ken Wright

Chip - admit it, you're just after an extra pressie in your stocking this
year <g>

Regards
Ken...............
 

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

Numbered list problem 6
Number entries are automatically divided by 100 - Excel 2003 1
Excel 08 divides numbers by 100 2
Excel divides every number I type in by 100 2
Number automatically divided by 100, why? 4
numeric entered automatically divided 100! 1
Excel 2007 dividing by 100 when it's not supposed to. 1
Numbers are automatically divided by 100 and I can't turn it off 3

Top