Thread: Change date from UK to US for one spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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?

Reply With QuoteReply With Quote