Prev: Can't open an excel file (have 2007, Vista) without saving fir
Next: Custom format Numbers
From: geordge7814 on 4 Mar 2010 13:42
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.
From: Fred Smith on 4 Mar 2010 14:06
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

"geordge7814" <geordge7814(a)discussions.microsoft.com> wrote in message
news:D39F8C1B-3DC6-4140-97C9-F269E36B9A4B(a)microsoft.com...
>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.

 | 
Pages: 1
Prev: Can't open an excel file (have 2007, Vista) without saving fir
Next: Custom format Numbers