formatting numbers in excel 2003

  • Thread starter Thread starter tammie
  • Start date Start date
T

tammie

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.
 
Back
Top