Excel 2003 not recognizing whole dollar amounts, formats amt as ce
 

In my earlier version of Excel, (Office 97), I could format the cells to
automatically enter amounts as dollars and cents. For example, I would type
30. and the amount was shown as $30.00. Or, I could type 4357, and the
amount was shown as $43.57. In the Office 2003 version if I type 30., the
amount is reflected in the cell as 30 cents instead of $30.00.

Yes that is a change that other people have complained about when one uses
fixed decimals

--
Regards,

Peo Sjoblom

(No private emails please)


"hat1" wrote in message
...
In my earlier version of Excel, (Office 97), I could format the cells to
automatically enter amounts as dollars and cents. For example, I would
type
30. and the amount was shown as $30.00. Or, I could type 4357, and the
amount was shown as $43.57. In the Office 2003 version if I type 30., the
amount is reflected in the cell as 30 cents instead of $30.00.