View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BCS BCS is offline
external usenet poster
 
Posts: 4
Default Importing CSV format issues

I am importing a CSV file into an Excel 2000 spreadsheet. One of the columns
is a timestamp. I have this column formatted as text in my Excel spreadsheet
and when I few the data in the CSV file using Notepad the timestamp is
indeed text format.

When I import the data from the CSV file into my Excel spreadsheet, the
timestamp comes in as text UNTIL it reaches a 2-digit hour and then the cell
is formatted as Time. Any ideas on why this is occuring and how I can remedy
it.

Thanks,

Barry