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!

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

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

Thank you - this is exactly what I needed.

"Dave Peterson" wrote:

> 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
>