Copied number (format as text) increases

J

James Wagner

Hi all.
I have a funny thing.

Formatted a column as text.
Put a number in row 1 - e.g. 50.00
Drag the number to row 2 -> the new cell value is 50.01.
Delete the number and try dragging to 10 cells - the new cells value
increases from 50.01 to 50.10...


Going to write the value - manually ....LOL

Please advise.
TIA
Guy
 
Õ

ÕýÔÚ¸üÐÂ...

please pressing "Ctrl" to drawing!!

I am chinese, i can't say more that in english!
so, i can't help you more!!!
 
J

James Wagner

Worked fine
Thank you sire!!!
Guy

?... said:
please pressing "Ctrl" to drawing!!

I am chinese, i can't say more that in english!
so, i can't help you more!!!
Click to expand...
 
Top