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

6

61Petrus

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting just the time portion 6
Date Maniplation 1
separating date and time 5
Problem formatting dates from CSV file 2
How to add day to PWA 2016 date format? 0
Extract Date formula Only 8
Peculiar default cell format 1
Extract the 2 Lowest % 3

Top