Change date from UK to US for one spreadsheet

[Lauren]

Our dates are set to US but I've received a spreadsheet from one of our UK
offices with dates formatted as d/m/y and I need them in US format.

How can I do this on the spreadsheet only?

 

[Gary''s Student]

Try this small macro:

Sub format_fixer()
For Each r In ActiveSheet.UsedRange
If r.NumberFormat = "d/m/yyyy" Then
r.NumberFormat = "m/d/yyyy"
End If
Next
End Sub

 

[Bob Phillips]

d/m/y is US format.

It shouldn't matter, Excel should manage it unless they are text.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

Scrub the comment about d/m/y being US format, but the other part is meant.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)