Leading Zeros

[John M]

I need to paste a series of numbers into my spreadsheet.
Some of these values have leading zeros which are
critical to the application. When I paste the values, I
lose the leading zeros. Is there a way to do the paste,
and retain the leading zeros?

 

[Peo Sjoblom]

Pre-format that range where you are pasting into as text and then paste
special as text works for me
Or use a custom format like 000000 if there is some rules behind the leading
zeros