Is it possible to keep leading zeroes for pasted numbers?

Deleted
Not applicable

Is it possible to retain leading zeroes in pasted numbers. I read through Microsoft's help steps and their solution to format as text does not work. These are UPC codes and I don't see any way of keeping the number as is, even when formatting as a number before or after pasting. Any help appreciated.

4 Replies

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place.

 

Please include the following info to help others answer your question:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Where are you pasting them from? Have you tried paste special, Values after formatting the area as text? If you want to keep the numbers as numbers, but display leading zeroes, format the cell as custom using 00000000 as format string (as many zeroes as the number of digits you have)
Yes, the help doesnt work for me too. It suggests using special and then tagging it as a phone number, but Excel doesn't allow that. Why is it so difficult to paste a number of phone numbers?
What is the source of these numbers precisely?