Not sure what you mean by "Field".

Code :
Range("A1").Value = Format(Date, "dd/mm/yy")

or, a simple formula in a cell :-
=NOW() and format cell accordingly

--
Message posted from http://www.ExcelForum.com