numbers are being divided by 100 on leaving cell

G

Guest

Excel 2003 SP2 - Part of Office standard edition
When entering numbers into a new or old worksheet they are automatically
being divided by 100 on leaving the cell. Example I type the number 1 and
it becomes 0.01 If I format the cell for currency then type 20 it becomes
£0.20 However if I type £20 that's how it stays. Is there a simple
explanation?
 
N

Niek Otten

Tools>Options>Edit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Excel 2003 SP2 - Part of Office standard edition
| When entering numbers into a new or old worksheet they are automatically
| being divided by 100 on leaving the cell. Example I type the number 1 and
| it becomes 0.01 If I format the cell for currency then type 20 it becomes
| £0.20 However if I type £20 that's how it stays. Is there a simple
| explanation?
 

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

Number entries are automatically divided by 100 - Excel 2003 1
Number entered in cell getting always divided by 100 ! 5
numbers in cells are automatically divided by 100. Not a format s. 1
Numbers divided by 100 3
Number Automatically divided by 100 and stored in cell 2
All number inputs are divided by 100 ? 2
Why are my cell being divided by 100? 2
Why are the data always divided by 10 in Excel? 1

Top