| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the date format when importing a txt file?
My import data imports as yyyy/mm/dd even when I tell it to import m/d/y.
When I try to format the column using format cells, custom, mm/dd/yyyy, I get ###########. I tried to change width of column as was suggested in help, but that does not work. I know I have done this before, but it escapes me now. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query Date Format | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| DATE Format | Excel Worksheet Functions | |||
| How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
| Change the format of my footer {date} option? | Excel Discussion (Misc queries) | |||
Threaded Mode
