Leading Zeros

  • Thread starter Thread starter John M
  • Start date Start date
J

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?
 
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
 
Back
Top