Excel divides number by 10e6 unless followed by decimal point.

[Guest]

When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to
change this?

 

[Fredrik Wahlgren]

When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to
change this?

Format|Cells select number and number of decimals
/Fredrik

 

[Dave Peterson]

Tools|options|Edit tab
uncheck that "fixed decimal places" box.

 

[Guest]

This is not a question of simply formating the cell, and specifying the
number of decimal points. General, Text, Number (with zero points) cell
formats all have the same result when a number is entered into the cell.

 

[Guest]

It worked. THANK YOU!!!

John O'Donnell

===========================

 

[Gord Dibben]

John

Tools>Options>Edit. Uncheck "Fixed Decimal Places".


Gord Dibben Excel MVP