You need to set the format yourself, FormatCellsCustom

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mnair" wrote in message
...
Hi,
Can any one of you please help me to get rid of the default excel dates to
standard format dates.