ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can I read date and time from ascii file? (https://www.excelbanter.com/excel-programming/286356-how-can-i-read-date-time-ascii-file.html)

Nazrul[_2_]

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

J.E. McGimpsey

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