ps. If you bring those dates as general or dates, excel will do its best to see
anything that looks like a date as a date.

01/02/2007
will January 2nd, 2007. Not the intended February 1, 2007.

So check your data against the original when you're done.

Albert wrote:

I work for an international company and when I download reports to excell or
access the dates and $$ come in European format, How can I reformat to
american? 24/8/2007 to 8/24/2007? and 1.000,00 to 1,000.00. Thanks!

--

Dave Peterson