If you can import those fields as text--not dates and numbers.

You can select (one column at a time)
data|text to columns
fixed width
choose dmy
and reformat them the way you like (m/d/yyyy or whatever)

Then you could select the numbers to fix
Edit|replace
what: . (a dot)
with: (leave blank)
replace all
And one more time
Edit|replace
what: , (a comma)
with: . (a dot)
replace all
and reformat the way you like.


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