Excel XP & Win XP
I have a 9 digit number. With VBA I copy that number to another cell.
Excel insists in displaying the number in the second cell in scientific
notation.
The original number is not a mathematical quantity so I can make it text.
Even if I do, it still pastes in scientific notation.
How can I copy/paste that entry as a 9 digit number? Thanks for your time.
Otto

> Excel XP & Win XP
> I have a 9 digit number. With VBA I copy that number to another cell.
> Excel insists in displaying the number in the second cell in scientific
> notation.
> The original number is not a mathematical quantity so I can make it text.
> Even if I do, it still pastes in scientific notation.
> How can I copy/paste that entry as a 9 digit number? Thanks for your
> time.

What happens if you copy it the way you do now (you didn't show us your
code), but make the column width wider... is it still in scientific
notation?

Rick

Rick
That did it. Thanks. Otto
"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>> Excel XP & Win XP
>> I have a 9 digit number. With VBA I copy that number to another cell.
>> Excel insists in displaying the number in the second cell in scientific
>> notation.
>> The original number is not a mathematical quantity so I can make it text.
>> Even if I do, it still pastes in scientific notation.
>> How can I copy/paste that entry as a 9 digit number? Thanks for your
>> time.
>
> What happens if you copy it the way you do now (you didn't show us your
> code), but make the column width wider... is it still in scientific
> notation?
>
> Rick