software

I agree, who ever changed the automatic decimal placement (that operates like
a calculator decimal setting) should be FIRED ! For financial data entry...
and dealing with $ dollars, why should we NOW have to stop to key in a
decimal pt? This is progress?

Not sure I understand what you mean; my calculator knows nothing about decimal points unless I tell it to apply one.

Maybe you were used to

Toolsgt;Optionsgt;Edit tab, quot;Fixed decimalquot; checked

and it got unchecked some way.

Just check.

--
Kind regards,

Niek Ottenquot;Program Icons Showing quot;arrowquot;quot; mgt; wrote in message
news
|I agree, who ever changed the automatic decimal placement (that operates like
| a calculator decimal setting) should be FIRED ! For financial data entry...
| and dealing with $ dollars, why should we NOW have to stop to key in a
| decimal pt? This is progress?
There has been a change in 2003 with regards how you enter using fixed
decimal places, assume 2 decimal places checked then in Excel 2002 entering
125. will return 125.00 thus the dot tells Excel not to set the decimals but
in 2003 you need to enter an extra zero like 125.0 or else you'll get 1.25
Don't know if that was what the OP meant though--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;Niek Ottenquot; gt; wrote in message
...
gt; Not sure I understand what you mean; my calculator knows nothing about
gt; decimal points unless I tell it to apply one.
gt;
gt; Maybe you were used to
gt;
gt; Toolsgt;Optionsgt;Edit tab, quot;Fixed decimalquot; checked
gt;
gt; and it got unchecked some way.
gt;
gt; Just check.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Program Icons Showing quot;arrowquot;quot;
gt; mgt; wrote in message
gt; news
gt; |I agree, who ever changed the automatic decimal placement (that operates
gt; like
gt; | a calculator decimal setting) should be FIRED ! For financial data
gt; entry...
gt; | and dealing with $ dollars, why should we NOW have to stop to key in a
gt; | decimal pt? This is progress?
gt;
gt;
quot;Peo Sjoblomquot; wrote:
gt; There has been a change in 2003 with regards how you
gt; enter using fixed decimal places, assume 2 decimal places
gt; checked then in Excel 2002 entering 125. will return 125.00
gt; thus the dot tells Excel not to set the decimals but in 2003
gt; you need to enter an extra zero like 125.0 or else you'll get
gt; 1.25

Gotta to be a bug, right? What sick kid would think that a
general (default) option setting should override an explicit
decimal point in the data entry? Besides, hasn't MS ever
heard of quot;backward compatibilityquot;? Okay, I know the answer
to that :-(. But I'm just saying: what sense can it ever make
to override the explicit decimal in data entry? This quot;mustquot; be
a defect. Please report it to MS, if it is not fixed already.