Decimal point will not hold 2 places in Excel 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helen - 21 Jun 2006 00:26 GMT

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.

Reply to this Message

Franz Verga - 21 Jun 2006 00:44 GMT

Nel post news:25521F22-8191-4466-BB57-12CE21B87C4D@microsoft.com
*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.

Signature

Hope I helped you.

Ciao

Franz Verga from Italy

Reply to this Message

Helen - 21 Jun 2006 05:35 GMT

Grazi!

> Nel post news:25521F22-8191-4466-BB57-12CE21B87C4D@microsoft.com
> *Helen* ha scritto:
[quoted text clipped - 8 lines]
>
> Menu Tools, Option tab Edit, clear the check box near Fixed decimals.

Reply to this Message

Franz Verga - 21 Jun 2006 10:10 GMT

Nel post news:9A3B208E-6E4E-4E8D-973B-F2157EDEFB4E@microsoft.com
*Helen* ha scritto:

> Grazi!

You're welcome.

Thanks for the feedback.

Signature

I'm glad I helped you.

Ciao

Franz Verga from Italy

Reply to this Message