Changing Date Format

[achin]

:help
I want to set the format for the date as defined below to "dd.mm.yyyy".

How should i do that?

If .Column = Range("G:G").Column And Cell = 1 Then
Cells(.Row, "H").Value = Int(Now)

[achin]

Sorry guys..
I've got the answer..
it's....

Cells.NumberFormat = "dd.mm.yyyy"

[Paul_Hossler]

Don't forget to mark it "Solved" under Thread Tools

Paul