international date settings

willhutchinson · Jan 27th 2006

hi could someone tell me how i can change the date settings within VBA, so i can change UK date format to US date format for an upload.

alring · Jan 27th 2006

Re: international date settings

Hi,

Why don't you format the cell to be US date format??

If you want to use VBA you can write this if the date is in A1:

Code

Sub date_format()


    Range("A1").Select
    Selection.NumberFormat = "m/d yyyy;@"


End Sub

Or you can under Sheet1 code write this code if the date is in A1:

Code

Private Sub date_format()


    Range("A1").Select
    Selection.NumberFormat = "m/d yyyy;@"


End Sub

carlmack · Jan 27th 2006

Re: international date settings

In addition, if you have international date issues this link might be of interest.

HTH

PS Also Format command eg. Format(Variable,"mm/dd/yy")

Participate now!