Convert European Date format to American Format

[Guest]

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]

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.

 

[Dave Peterson]

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.

 

[Guest]

Thank you - this is exactly what I needed.

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.