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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can scientific notation be turned off? 1
Copy/paste number as text 1
Converting a number (17 characters) to text (Scientific Notation) 4
Scientific Notation - I wish MS Gave us a switch to turn it off 3
Number format in CSV file 1
Turn Off Scientific Notation 3
large numbers as text replaced with scientific notation 2
Turn Off Scientific Notation 1

Back
Top