try

HDRDATE = format(HDRDATE,"mm/dd/yy")

--
When you lose your mind, you free your life.


"waynehinds" wrote:


Thanks for replies..

I want to now set this value to the date format "mm/dd/yy" and put in
header.

It is currently printing in header but it is printing m/d/yyyy


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=388444