USA to UK Dates

V

Vass

I have a list of data extracted from elsewhere and the dates are in USA
format
i.e. mm/dd/yyyy

Can excel swap this around to UK format dd/mm/yyyy ?

thanks in advance
 
G

greg7468

Hi,
Format the dates to dd/mm/yyyy

Highlight the dates

Format > Cells > Number tab > Date > choose the one you need

If it is not in there go to Custom and put dd/mm/yyyy in the space
provided under Type.

HTH.
 

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

Can I change a column of dates from USA to UK format? 3
Convert dates stored as text 2
Date Formats 1
Excel 2007 displayed dates 2
Date Conversion 4
date 1
reformat dates to yyyy/mm/dd 5
How can I change a date to UK format without shuffling the actual 3

Top