| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/paste number as text
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format Changes During VBA Copy/Paste | Excel Discussion (Misc queries) | |||
| Copy & paste block of text number of times equal to value in cell | Excel Worksheet Functions | |||
| VBA text for copy + paste | Excel Discussion (Misc queries) | |||
| Copy and Paste Number from Notepad | Excel Discussion (Misc queries) | |||
| How to copy and paste number formats only? | Excel Programming | |||
Threaded Mode
