MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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