Decimal point will not hold 2 places in Excel 2003

G

Guest

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

Franz Verga

Nel post *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.
Click to expand...


Hi Helen,

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

--
Hope I helped you.

Ciao

Franz Verga from Italy
 
G

Guest

Grazi!

Franz Verga said:
Nel post *Helen* ha scritto:



Hi Helen,

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

--
Hope I helped you.

Ciao

Franz Verga from Italy
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal point in general format 1
Access stripping decimal places in query 1
Automatically entered decimal point. 8
Excel Excel 2007 won't stop rounding down my formula results! 5
how do I automatically insert a decimal point? 1
Convert number to text as displayed 3
Fixed Decimal 2
Tools>options>edit>Fixed decimal places = 2 1

Top