Number Format Incorrect

[Guest]

Prior to today, this has not been a problem. When I enter a number
(formatted as number, 0 decimals), the last two digits are not showing.

i.e. entered 10500, the number shown in the cell is 105
i.e. entered 10511, the number shown in the cell is 105

Using General format, enter 10511, the number shown is 105.11

How do I correct so the number shown is correct.

 

[RagDyeR]

<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Fixed Decimal Places"
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Prior to today, this has not been a problem. When I enter a number
(formatted as number, 0 decimals), the last two digits are not showing.

i.e. entered 10500, the number shown in the cell is 105
i.e. entered 10511, the number shown in the cell is 105

Using General format, enter 10511, the number shown is 105.11

How do I correct so the number shown is correct.

 

[Guest]

Linda

You could look at tools>options>edit>fixed decimal

Mike Rogers

 

[Guest]

Thank you all very much. It worked!