View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Helen
 
Posts: n/a
Default Decimal point will not hold 2 places in Excel 2003

I formatted the cells as Number and/or Currency, repaired, and reinstalled.
If I enter an amount like five dollars, I have to enter the entire "5.00" or
it will show as ".05". If I enter just " 5" it shows as .05 (five cents).
In Excel 2000, I only had to enter "5" and the decimal and two zeros appeared
after the 5.