Hi All,
I have dates in dd/mm/yy format that are formatted as text. If I change the format to date dd-mmm-yy, nothing happens. If I paste-special multiply by 1 and then format as date, the month and day are switched. I checked the regional settings for my computer and they are set to dd/mm/yy. I formatted a cell as date dd-MMM-yy and typed in 08/05/03 which showed up properly as 08-May-03. Any thoughts why the conversion from text to date is behaving so badly?
Thanks,
Jen