![]() |
how can I read date and time from ascii file?
I have an ascii file to read date, time, data1 and data2
as shown below from EXCEL. 1999-10-25 00:00:00 0 0 1999-10-25 00:03:00 3.657 0 1999-10-25 00:06:09 3.657 26831.4 I can read data1 and data2 correctly, but not date and time. Is there somebody who can help me out? Nazrul |
how can I read date and time from ascii file?
If you're using the Text wizard to bring the file in, on the third
pane, select the date column and choose YMD from the date dropdown. I'm not sure what trouble you're having with time - what are you seeing? In article , "Nazrul" wrote: I have an ascii file to read date, time, data1 and data2 as shown below from EXCEL. 1999-10-25 00:00:00 0 0 1999-10-25 00:03:00 3.657 0 1999-10-25 00:06:09 3.657 26831.4 I can read data1 and data2 correctly, but not date and time. Is there somebody who can help me out? |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com