PDA

View Full Version : Changing Date Format



achin
04-27-2008, 09:11 PM
: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
04-27-2008, 10:22 PM
Sorry guys..
I've got the answer..
it's....

Cells.NumberFormat = "dd.mm.yyyy"

Paul_Hossler
04-28-2008, 05:41 PM
Don't forget to mark it "Solved" under Thread Tools

Paul