ExcelBanter - date format of "2005022011075" in Office 2000, is not recognized .

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - date format of "2005022011075" in Office 2000, is not recognized . (https://www.excelbanter.com/excel-discussion-misc-queries/18554-date-format-%222005022011075%22-office-2000-not-recognized.html)

OlieH

date format of "2005022011075" in Office 2000, is not recognized .

I am getting an external date from "some system" in the above format. Does
Excell allow me to conviently format this without pulling it apart piece by
piece?

JulieD

Hi Olie

what date does your example equate to?

Cheers
JulieD

"OlieH" wrote in message
...
I am getting an external date from "some system" in the above format. Does
Excell allow me to conviently format this without pulling it apart piece
by
piece?

All times are GMT +1. The time now is 12:54 PM.