Hi,

active the cells that you want to change, right click on the active cells,
choos format cells, choos the tab "Number", choos costom, enter in the type
textbox: mm-dd-yyy or mm/dd/yyy and then click OK

Thanks,
--
Farhad Hodjat


"Diana G." wrote:

I have dates that were sent to me in the European format (22-5-2006) and I
need to convert them to the American format (5-22-2006). How can I do this
without changing each one manually? Thx~