VBA for changing Date format

[thisisrahul]

Is there a way to change the date format from dd/mm/yyyy to mm/dd/yyyy using VBA code?

 

[pgc01]

Hi

You can set it manually and use the macro recorder to get the code.

 

[Arithos]

Yes to what pgc01 said.

Using the format function also works nicely for theese things.

If cells(1,1) contains the date, use this:

Cells(1, 1) = Format(Cells(1, 1), "mm/dd/yyyy")