View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Avoid Scientific Notation

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