Avoid Scientific Notation

[Otto Moehrbach]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Otto Moehrbach]

Rick
That did it. Thanks. Otto

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