| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I CHANGE QUERY DATA TO A DATE RANGE?
I download a query that has a column of dates displayed without the
seperators (20040830). When I try to convert these cells to reflect a date, nothing changes. No matter what I tell the format to llok like, it remains as 20040830. I can only change this to 2004/08/30 or 30/08/2004 by physically going in and changing it in each cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Data range properties | Excel Discussion (Misc queries) | |||
| data range properties | Excel Discussion (Misc queries) | |||
| 1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
Threaded Mode
