Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fixed decimal place
I have my fixed decimal at 2 but when want to override it and type "50." it
still gives me an answer of .50 rather than overriding the fixed decimal and giving me 50.00. Any idea's? Excel 2003 |
#2
|
|||
|
|||
Cherie
Excel 2003 has made a slight change in the FD override. You must now enter 50.0 rather than 50. Gord Dibben Excel MVP On Tue, 3 May 2005 08:05:04 -0700, CheriFireFox wrote: I have my fixed decimal at 2 but when want to override it and type "50." it still gives me an answer of .50 rather than overriding the fixed decimal and giving me 50.00. Any idea's? Excel 2003 |
#3
|
|||
|
|||
Why did excel do this and how do we get them to change it back or give us
long time users the option of having it the old way. This is a major problem for people who enter lots of data. Where could I suggest this to Microsoft? Any ideas? Thanks "Gord Dibben" wrote: Cherie Excel 2003 has made a slight change in the FD override. You must now enter 50.0 rather than 50. Gord Dibben Excel MVP On Tue, 3 May 2005 08:05:04 -0700, CheriFireFox wrote: I have my fixed decimal at 2 but when want to override it and type "50." it still gives me an answer of .50 rather than overriding the fixed decimal and giving me 50.00. Any idea's? Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting a floating decimel point | New Users to Excel | |||
decimal place and merging to word doc. | Excel Worksheet Functions | |||
excel validation to 1 decimal place | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |