formatting numbers in excel 2003

In Excel 2000 I could set my format to number, 2 decimals,
place comma, and fixed decimals would be checked in the
tools, options.

When I enter 329 and press enter I would get 3.29 in cell
When I enter 329. and press enter I would get 329.00 in
cell.

I cannot make this work in 2003 If I have it set as
describted above I get 3.29 in either case. Please tell
me what to do. 20 years of entering this way will not
change overnight if I cannot find the problem.

Any help is greatly appreciated.

tammie

This appears to be an inadvertant change in XL2003.

See this thread from a google search.

http://snipurl.com/6i4k

Gord Dibben Excel MVP

On Tue, 18 May 2004 09:18:42 -0700, "tammie"
wrote:

In Excel 2000 I could set my format to number, 2 decimals,
place comma, and fixed decimals would be checked in the
tools, options.

When I enter 329 and press enter I would get 3.29 in cell
When I enter 329. and press enter I would get 329.00 in
cell.

I cannot make this work in 2003 If I have it set as
describted above I get 3.29 in either case. Please tell
me what to do. 20 years of entering this way will not
change overnight if I cannot find the problem.

Any help is greatly appreciated.