numbers are being divided by 100 on leaving cell
 

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?

numbers are being divided by 100 on leaving cell
 

ToolsOptionsEdit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Derick" wrote in message ...
| 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?

numbers are being divided by 100 on leaving cell
 

Tools/ Option/ Edit
Uncheck fixed decimal places.
--
David Biddulph

"Derick" wrote in message
...
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?

numbers are being divided by 100 on leaving cell
 

Thank you. It had to be simple

"Derick" wrote:

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?

numbers are being divided by 100 on leaving cell
 

Thank you. It had to be simple

"David Biddulph" wrote:

Tools/ Option/ Edit
Uncheck fixed decimal places.
--
David Biddulph

"Derick" wrote in message
...
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?