Avoid Scientific Notation

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

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
 
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.
Click to expand...

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) said:
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
Click to expand...
 
Back
Top