Alan,

The problem is that the data is being copied out of a web page that includes
multiple columns of data, if I set it to text, it does import the 0s however,
it puts all three columns of data in the same column. Any ideas on cleaning
that up?

Tom Schmitt

"Alan Perkins" wrote:

Tom, one way to do it:

Format the target cell(s) as Text. Then select Edit | Paste Special | Text
from the Excel menu.

HTH

Alan P.

"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.