How to easily convert US to UK date formats?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read similar problems on the Knowledgebase.

Our different systems use US and UK date formats, so I like to format the
whole column to read as '14-Mar-01' to avoid confusion.

But looking within a cell, it might have been downloaded as 06/05/07 (it's a
real problem in these middle months of the year) but I know it should be
05/06/07

Is there a formula that I could put in a cell alongside, which I could then
copy down the hundreds of other rows for the monthly (or yearly data)?
 
I think you need to expand. How do you 'know' that "06/05/07 should be
05/06/07"?
best wishes
 

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

How to easily migrate PST to Zoho account? 2
Uk Date Format to US Date Format 8
Converting US Dates to UK Formats 4
2 dimensional date sort 1
Need to transform the dates to months 4
convert US dates to UK dates 2
Count based on multiple criteria 2
Modifying a complex date formual to count months 4

Back
Top