Version 2003 Fixed Decimal Glitch

[Barbara]

I've encountered an unhandy feature with the fixed decimal option in the
new 2003 version of excel. With older versions, once the fixed decimal
option under Tools-Options-Edit was checked, one could enter a whole
number by entering the number with a decimal point only -- no following
zeroes were needed. If I wanted to enter the number 25, for example, I
would enter 25 followed by a decimal point. With the new version,
however, I'm having to enter the zeroes also, as in 2500 or 25.00.
This somewhat defeats the utility of this option. Have any others
encountered this glitch with excel 2003?

 

[Peo Sjoblom]

Whether it is a glitch or not I don't know, it might have been considered to
be a glitch before (according to MS that is),
frankly I have never found it usable in any way but I went back and checked
and in 2002 you can have
2 fixed decimal places and enter 2. and it will return 2 but if you do the
same in 2003 it will return 0.02
So I guess if you are used to this it might be annoying. Compared to the
change to the Help function it is
nothing, now that is really annoying.

 

[JE McGimpsey]

Yes. It's a bug.

 

[Barbara]

Yes. You are right -- compared to the new "Help" this is nothing