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,
--
George Nicholson

Remove 'Junk' from return address.


"Tom" wrote in message
...
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.