Excel XP & Win XP
I have a bunch of 10-digit contract numbers I need to copy and paste in
a VBA routine. Say I have 1234567895. I am using "PasteSpecial
xlPasteValues" because I don't want to carry the formatting over to the
destination (colors, font size, etc).
Excel insists on pasting the numbers in scientific notation.
I tried formatting the destination cell to Text before pasting.
I tried formatting the source cell to Text before copying.
I tried both at the same time.
The pasted number is still in scientific notation.
How can I copy/paste the contract number in its original form?
Thanks for your time. Otto

Thanks Tom. I'll give that a try in the morning. Otto
"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news858DEB4-B630-4409-B276-(E-Mail Removed)...
> If you really want it as text, then don't paste
>
> dim dest as Range, source as Range
> set dest =
> set source =
>
> dest.Value = "'" & source.value
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Otto Moehrbach" wrote:
>
>> Excel XP & Win XP
>> I have a bunch of 10-digit contract numbers I need to copy and paste
>> in
>> a VBA routine. Say I have 1234567895. I am using "PasteSpecial
>> xlPasteValues" because I don't want to carry the formatting over to the
>> destination (colors, font size, etc).
>> Excel insists on pasting the numbers in scientific notation.
>> I tried formatting the destination cell to Text before pasting.
>> I tried formatting the source cell to Text before copying.
>> I tried both at the same time.
>> The pasted number is still in scientific notation.
>> How can I copy/paste the contract number in its original form?
>> Thanks for your time. Otto
>>
>>
>>