ExcelBanter - how to convert 19900301 to 03/01/1990

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

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

- - how to convert 19900301 to 03/01/1990 (https://www.excelbanter.com/excel-discussion-misc-queries/69263-re-how-convert-19900301-03-01-1990-a.html)

Gary''s Student

how to convert 19900301 to 03/01/1990

Use the DATE() function:

If 19900301 is in A1 then =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
will get you the value in date form.
--
Gary''s Student

"clarice" wrote:

how can a date that is set up in excel as 19900301 be converted automatically
to read 03/01/1990?

All times are GMT +1. The time now is 05:27 PM.