MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Zeros at the beginning of a record


Posted by Matt on February 13, 2002 12:03 PM

I am trying to copy a list of numbers from notepad to Excel. Myy problem is that when I paste into Excel, it doesn't keep the zeros at the beginning of the number, which I need it to do. 00670395889 copies to excel as 670395889. Any help would be appreciated.


Posted by Mark W. on February 13, 2002 12:19 PM

Format the receiving cell(s) as Text before you
Paste.