Copy/paste number as text

O

Otto Moehrbach

Excel XP & Win XP
I have a bunch of 10-digit contract numbers I need to copy and paste in
a VBA routine. Say I have 1234567895. I am using "PasteSpecial
xlPasteValues" because I don't want to carry the formatting over to the
destination (colors, font size, etc).
Excel insists on pasting the numbers in scientific notation.
I tried formatting the destination cell to Text before pasting.
I tried formatting the source cell to Text before copying.
I tried both at the same time.
The pasted number is still in scientific notation.
How can I copy/paste the contract number in its original form?
Thanks for your time. Otto
 

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

Visio shape text disappears upon copy paste 1
How to paste this down? 3
Copy/Paste (Clipboard) Issues 1
Avoid Scientific Notation 2
Copy columns and paste with blank column between 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Macro to Copy/Paste Multiple images 3
Macro will copy formula instead of value 6

Top