Excel 2003 & Fixed Decimal Places

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
 
D

DougChurch

Aless said:
*In Excel 2003 Tools>Options>Edit>Fixed Decimal Places is set at
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 fo
the
number to show up correctly as a whole number and its leading t
many
mistakes in data entry and becoming extremely annoying as I hav
become used
to simply entering a decimal point to get a whole number.

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

Al
Click to expand...


-
DougChurc
 
D

DougChurch

This problem is killing me! The help screens in Excel 2003 still list
decimal point as a work-around. Does anyone have any suggestions?
*In Excel 2003 Tools>Options>Edit>Fixed Decimal Places is set at
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 fo
the
number to show up correctly as a whole number and its leading t
many
mistakes in data entry and becoming extremely annoying as I hav
become used
to simply entering a decimal point to get a whole number.

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

Al
Click to expand...


-
DougChurc
 
Top