| 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. |
| 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) | |||
Threaded Mode
