That's because the dates are text, you have to make them numbers, what are
the date settings in your regional options/settings in windows control
panel?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Gerald" wrote in message
...
I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from FormatCustommm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks