Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Decimal key on keypad is ignored
In Excel 2000 with fixed decimal 2 places in the setup, I could enter 10+.
and the cell would read 10.00. In 2003, the decimal is ignored and I must enter 1000 to get 10.00. Is there a way to fix this change? |
#2
|
|||
|
|||
The functionality has not changed in Excel 2003, the fixed decimal is
overridden if you manually enter the decimal. I would check a couple of things 1) Your decimal separator under windows regional settings is . 2) If you are wanting to use the system separators, as above, you make sure that setting is checked in Excel ToolsOptionsInternationalUse system settings Of course, you can opt to not use system settings and then make the entry in the relevant box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "eidsonva" wrote in message ... In Excel 2000 with fixed decimal 2 places in the setup, I could enter 10+. and the cell would read 10.00. In 2003, the decimal is ignored and I must enter 1000 to get 10.00. Is there a way to fix this change? |
#3
|
|||
|
|||
The behaviour of Fixed Decimals has been changed in Excel 2003.
Why?, you ask. No idea. You must now enter 10.0 to get 10 10. returns .01 as you found out. Gord Dibben Excel MVP On Wed, 12 Jan 2005 12:43:06 -0800, "eidsonva" wrote: In Excel 2000 with fixed decimal 2 places in the setup, I could enter 10+. and the cell would read 10.00. In 2003, the decimal is ignored and I must enter 1000 to get 10.00. Is there a way to fix this change? |
#4
|
|||
|
|||
Gord
Sorry, missed the OP saying just 10. Presumed 10.00 my mistake...learned something too that it changed though, never used that setting...that's my learning for today -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Gord Dibben" <gorddibbATshawDOTca wrote in message ... The behaviour of Fixed Decimals has been changed in Excel 2003. Why?, you ask. No idea. You must now enter 10.0 to get 10 10. returns .01 as you found out. Gord Dibben Excel MVP On Wed, 12 Jan 2005 12:43:06 -0800, "eidsonva" wrote: In Excel 2000 with fixed decimal 2 places in the setup, I could enter 10+. and the cell would read 10.00. In 2003, the decimal is ignored and I must enter 1000 to get 10.00. Is there a way to fix this change? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
Format decimal controls do not work | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) |