G geordge7814 Mar 4, 2010 #1 i have a file in 2003 excel, one field is in text delimited format. How do i convert this without lossing the '0' at the beginning of the number.
i have a file in 2003 excel, one field is in text delimited format. How do i convert this without lossing the '0' at the beginning of the number.
F Fred Smith Mar 4, 2010 #2 Do you have an Excel file (.xls) or a CSV file? If it's Excel, 2007 will read it in properly. If it's CSV, specify the field as text during the open. Regards, Fred
Do you have an Excel file (.xls) or a CSV file? If it's Excel, 2007 will read it in properly. If it's CSV, specify the field as text during the open. Regards, Fred