Numbers starting in 0

S

Scott

I have a csv file that has PO numbers in it. Some of the PO numbers start
with zero, which is required. When I open the file in Excel 2002, Excel
drops the zero off thinking it is a number not text. How can I keep Excel
from dropping the 0 off?
 
M

mzehr

Hi,
Try changing the file extenstion to .txt When you import
the file, set the column with the PO numbers to text
 
Top