Thread: in 2003 i have 0 text file conrt to 2007 number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default in 2003 i have 0 text file conrt to 2007 number
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" wrote in message
...
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.

Reply With QuoteReply With Quote