Decimal point will not hold 2 places in Excel 2003  
Author Message
thenextrocky





PostPosted: Tue Jun 20 18:44:21 CDT 2006 Top

worksheet functions >> 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.

Excel266  
 
 
Franz





PostPosted: Tue Jun 20 18:44:21 CDT 2006 Top

worksheet functions >> Decimal point will not hold 2 places in Excel 2003
*Helen* ha scritto:

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


Hi Helen,

Menu Tools, Option tab Edit, clear the check box near Fixed decimals.

--
Hope I helped you.

Ciao

Franz Verga from Italy


 
 
Helen





PostPosted: Tue Jun 20 23:35:02 CDT 2006 Top

worksheet functions >> Decimal point will not hold 2 places in Excel 2003 Grazi!




> *Helen* ha scritto:
>
> > 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.
>
>
> Hi Helen,
>
> Menu Tools, Option tab Edit, clear the check box near Fixed decimals.
>
> --
> Hope I helped you.
>
> Ciao
>
> Franz Verga from Italy
>
>
>
 
 
Franz





PostPosted: Wed Jun 21 04:10:05 CDT 2006 Top

worksheet functions >> Decimal point will not hold 2 places in Excel 2003
*Helen* ha scritto:

> Grazi!

You're welcome.

Thanks for the feedback.

--
I'm glad I helped you.

Ciao

Franz Verga from Italy