Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP format issues? Craig4321 Excel Worksheet Functions 4 June 15th 09 07:06 PM
Stock Format Issues LiAD Charts and Charting in Excel 2 January 11th 09 03:16 PM
.txt format issues C Brandt Excel Discussion (Misc queries) 1 June 19th 07 10:44 PM
Sumproduct and format issues Curtis Excel Worksheet Functions 4 March 17th 07 10:26 AM
Importing a .txt file issues Mariano Excel Discussion (Misc queries) 5 January 26th 06 07:25 PM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"