| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing dates to date format
I copy paste around 2 thousand dates in a website ( htlm format ) into
my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates to date format
Can you share with those of us not familiar with web stuff an example or two
of what an "htlm format" date looks like? -- Rick (MVP - Excel) "Tigerxl" wrote in message ... I copy paste around 2 thousand dates in a website ( htlm format ) into my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates to date format
Sure Rick and thank for your interest.
Dates look like this : 12/31/08 12/30/08 12/29/08 Etc. on the cells and on the formula bar too. "Rick Rothstein" wrote: Can you share with those of us not familiar with web stuff an example or two of what an "htlm format" date looks like? -- Rick (MVP - Excel) "Tigerxl" wrote in message ... I copy paste around 2 thousand dates in a website ( htlm format ) into my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates to date format
They look like standard dates to me, although I guess they could be Text
that looks like a date. I would think your formula should work even if those cells are formatted as Text, so I think something else is wrong. Since you got these dates from the web, perhaps you brought along a stray invisible character or two. If the month portion of your dates contain a leading zero for one-digit month numbers, then try this formula and see if it works... =TEXT(LEFT(A1,8),"ddd") -- Rick (MVP - Excel) "Tigerxl" wrote in message ... Sure Rick and thank for your interest. Dates look like this : 12/31/08 12/30/08 12/29/08 Etc. on the cells and on the formula bar too. "Rick Rothstein" wrote: Can you share with those of us not familiar with web stuff an example or two of what an "htlm format" date looks like? -- Rick (MVP - Excel) "Tigerxl" wrote in message ... I copy paste around 2 thousand dates in a website ( htlm format ) into my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates to date format
DataText to columnsNextNextColumn Data FormatDateMDY and Finish.
Now try the formula. Gord Dibben MS Excel MVP On Thu, 2 Apr 2009 16:51:01 -0700, Tigerxl wrote: Sure Rick and thank for your interest. Dates look like this : 12/31/08 12/30/08 12/29/08 Etc. on the cells and on the formula bar too. "Rick Rothstein" wrote: Can you share with those of us not familiar with web stuff an example or two of what an "htlm format" date looks like? -- Rick (MVP - Excel) "Tigerxl" wrote in message ... I copy paste around 2 thousand dates in a website ( htlm format ) into my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates to date format
It sure worked.
Thank you Gord Dibben. "Gord Dibben" wrote: DataText to columnsNextNextColumn Data FormatDateMDY and Finish. Now try the formula. Gord Dibben MS Excel MVP On Thu, 2 Apr 2009 16:51:01 -0700, Tigerxl wrote: Sure Rick and thank for your interest. Dates look like this : 12/31/08 12/30/08 12/29/08 Etc. on the cells and on the formula bar too. "Rick Rothstein" wrote: Can you share with those of us not familiar with web stuff an example or two of what an "htlm format" date looks like? -- Rick (MVP - Excel) "Tigerxl" wrote in message ... I copy paste around 2 thousand dates in a website ( htlm format ) into my XL 2003, column A. Now the formula (=text(A2,"ddd") does not reconize the format in those dates. How can I change those dates to date format in XL. I tried formatcelldateMarch 14,2001 and it did not work. THANK YOU. PS I can not sort them either. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing text dates to date serial numbers | Excel Worksheet Functions | |||
| changing dates in a date formated column ? | Excel Discussion (Misc queries) | |||
| convert Excel sheet in 1904 format to 1900 without changing dates | Excel Worksheet Functions | |||
| changing date format | New Users to Excel | |||
| Dates keep changing to US format when mail merging | Excel Discussion (Misc queries) | |||
Hybrid Mode
