Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Copy number, paste as text.

Posted by Gerry T on October 23, 2001 6:54 AM
I would like to copy a zipcode from a different program and paste it into excel. The problem is that it pastes it as a number. This creates a problem when the zipcode starts with a zero. ex: 08325 Excel wants to convert it to a number and the zero drops off. Is there a way to paste into excel and keep the text format? I tried to format the cell before pasting, but it still converts the cell to number format. If you copy the above zipcode and paste it into excel you will see what I mean. I appreciate any help you can give me.

Re: Copy number, paste as text.

Posted by Mark W. on October 23, 2001 6:59 AM
Format the receiving cell as "Text" and perform
a Paste Special... Values instead of a standard

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.