Hi veryone

G

Guest

Ok, I've got this problem. When i use autofill for
decimal numbers like 50.45, 50.50 , 50.55 , about after
10 numbers in the column the nuber appears not for
example like 50.55 but 50.54444444, which is incorrect.
Can someone explain how to fix that?Thanks in advance
 
R

RagDyer

Interesting !

I get the same thing.

Don't know why, though.
--

Regards,

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



Ok, I've got this problem. When i use autofill for
decimal numbers like 50.45, 50.50 , 50.55 , about after
10 numbers in the column the nuber appears not for
example like 50.55 but 50.54444444, which is incorrect.
Can someone explain how to fix that?Thanks in advance
 
C

Casey

Hi,
I suspected that it could be a cell formatting problem. So I formatted
the cells using FORMAT>CELLS>NUMBER and selected Number and selected 2
decimal places. Then the autofil function worked perfectly.

Casey :)
 
R

RagDyer

Not for me !
In XL 2K *and* 02
Both exhibit the same anomaly, with the numbers format and/or the general
format.

Does anyone else have 2 ¢ to add to this ?
--


Regards,

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

Hi,
I suspected that it could be a cell formatting problem. So I formatted
the cells using FORMAT>CELLS>NUMBER and selected Number and selected 2
decimal places. Then the autofil function worked perfectly.

Casey :)
 
Top