decimal point override does not work

A

AL

I have fixed decimal point option on, but when I want to override the fixed
decimal point by placing a "." after the number I enter, it still places the
decimal point. For example: I want to enter the number 4,655.00 so I type
"4655." and I get 46.55. I do still want the fixed decimal point, but when I
have numbers that are #.00 I do not want to have to add "00" to every number.
 
M

Myrna Larson

If what you've tried doesn't work, then the only solution is to enter the
extra two zeroes, i.e. type 465500.
 
D

Debra Dalgleish

If you're using Excel 2003, the override doesn't work as expected. You
can add a decimal and a zero at the end of the number, to override the
fixed decimals. For example, type 33.0 and it will be entered as 33
 
S

Sam Brauen

Is there any update to dload or anything? I work in excel all day everyday
and this is very annoying to have to add ".0" or "00" to everything.

I am running Office 2003 on Windows xp
 
Top