The custom format idea works for the display, but it does not carry over to
what I need to do with the number. Each of these cells represents part of an
E-mail address and I need all the numbers to make it work. I am using a
formula such as " When I apply the formula I lose the
zero at the front again...any ideas?

"Tom" wrote:

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.