Copied number (format as text) increases

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!!!

--
²»¶Ïg¨¥ngУ¬²»¶Ïg¨¨ngУ¡
"James Wagner" <[email protected]> дÈëÏûÏ¢ÐÂÎÅ:[email protected]...
> 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
>

Worked fine
Thank you sire!!!
Guy

"?..." <[email protected]> wrote in message
news:[email protected]...
> please pressing "Ctrl" to drawing!!
>
> I am chinese, i can't say more that in english!
> so, i can't help you more!!!
>
> --
> gng£gng£
> "James Wagner" <[email protected]>
> ??:[email protected]...
>> 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
>>
>
>