| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
