| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert an Excel file to an ASCII file? | Excel Discussion (Misc queries) | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| Read data from ascii file | Excel Programming | |||
| Open file to write and read at the same time | Excel Programming | |||
| Selective read data from ascii file | Excel Programming | |||
![Nazrul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
