| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date recognition problem
Thanks to all. Very helpful
Chandler "Ragdyer" wrote: TTC (Text To Columns) should convert that data to XL recognizable dates quite easily, just by opening and closing TTC. Select the column of imported dates, then click: <Data <Text To Columns <Finish And you should now have a column of XL "legal" dates. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Chandler" wrote in message ... Hi. My problem is that I import a table with a number of columns (using "New web query"), one of which (D) is a column of dates in the form "08 July 2007" (two spaces between the number and month as it happens). In Import External Data - Options I am forced to select Disable Date Recognition due to the content of another of the columns which is misread otherwise. Once the table is imported into the worksheet I need to get Excel (2003) to recognise the date column (i.e. D) as dates, which it refuses to do even if I select the column and Format - Cells... - Date it, or correct the two spaces into the next column using =LEFT(D1,2)&RIGHT(D1,LEN(D1)-3) and then formatting that column using Format - Cell - Date. Excel will recognise the individual D cells as dates if I click the cursor in each one first but this is not a feasible solution since the column of dates is very long. I'd be grateful if anyone knows a solution. My suspicion is that there isn't one. Regards Chandler |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Date Recognition | Excel Discussion (Misc queries) | |||
| problem of recognition of numbers in Excel | Excel Discussion (Misc queries) | |||
| Sum function based on Date recognition | Excel Discussion (Misc queries) | |||
| Disable Date Recognition | Excel Discussion (Misc queries) | |||
| Disable Date Recognition? | Excel Discussion (Misc queries) | |||
Threaded Mode
