u could try using activecell.value=format(activecell.value,mm/dd/yyyy)
or as ur requirement is the normal date format u could just save the value
to a variable declared as date and store it again in the destination cell
regards
nc

"JDMocko" wrote:

How do I convert dates from yyyymmdd120000[0:GMT] to mm/dd/yyyy in Excel 2003?