you could format the cell as custom and have as many zero's as you want. all
our account codes have 7 numbers, sometimes starting as 00xxxxx. format the
cell as"0000000" and you only need to input xxxxx to get 00xxxxx
George Nicholson wrote:
Set up the range you are pasting to with a Custom format that includes
leading zeros.
Copy your data. Use PasteSpecialValues to paste.

Note: the underlying contents of the cell will not actually include the
leading zero, but the leading zero will *display* as specified.
If you want to actually store the leading zero then you'd have to store it
as alpha-numeric text. Numbers don't have leading zeros (except zero
itself).

HTH,
I need to paste numbers to Excel that sometimes begin with 0. How do I do
this without losing the lead 0? I am using Office 2000. You advice is
appreciated.