ExcelBanter - Converting Day, Date Month Year format to MM/DD/YYYY

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Converting Day, Date Month Year format to MM/DD/YYYY (https://www.excelbanter.com/excel-worksheet-functions/177209-converting-day-date-month-year-format-mm-dd-yyyy.html)

61Petrus

Converting Day, Date Month Year format to MM/DD/YYYY

I would like to convert cells formatted as

Tue, 4 Oct 1966 00:00:00

to

10/4/1966

How would this best be accomplished.

Gary''s Student

Converting Day, Date Month Year format to MM/DD/YYYY

Format Cells... Number Custom m/d/yyyy
--
Gary''s Student - gsnu200769

All times are GMT +1. The time now is 10:04 AM.