Forum Discussion
Is it possible to keep leading zeroes for pasted numbers?
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 kee...
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)