Change date from UK to US for one spreadsheet
 

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?

Change date from UK to US for one spreadsheet
 

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

--
Gary''s Student - gsnu200771


"Lauren" wrote:

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?

Change date from UK to US for one spreadsheet
 

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)



"Lauren" wrote in message
...
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?

Change date from UK to US for one spreadsheet
 

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)



"Lauren" wrote in message
...
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?