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

Avoid Scientific Notation 2
Copy columns and paste with blank column between 5
Macro will copy formula instead of value 6
How to copy and paste row as a text within workbook including numbers 5
Converting a number (17 characters) to text (Scientific Notation) 4
Number stored as text 4
Conditional Formatting 1
Number format in CSV file 1

Top