Excel 2003 & numbers display problem

A

Aless

In Excel 2003 Tools>Options>Edit>Fixed Decimal Places is set at 2 but values
entered in a cell are displayed differently from earlier versions:

Cell Entry Displayed in 2003 Displayed in Excel XP
175 1.75 1.75
175. 1.75 175.00
175.0 175.00 175.00

It now seems necessary to enter a zero after the decimal point for the
number to show up correctly as a whole number and its leading to many
mistakes in data entry and becoming extremely annoying as I have become used
to simply entering a decimal point to get a whole number.

Is there any way of changing this to "normal"?

Al
 

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

Excel 2003 & Fixed Decimal Places 3
Help with fixed decimal 4
Fixed Decimals in Excel 2007 4
Match worksheet Function displays wrong data on calculation 1
Cell displays #'s incorrectly 3
Excel 2007 adding a column of negative and positive number 2
Decimal points data not displaying as expected 2
Number Format Problem 2

Top