text or american date format

I have an import from a finance package that has put a data column into the
american date format or maybe a general text format. How do i convert to
dd/mm/yyyy
--
Marshall

Just change the display format:

=TODAY() formatted as General shows 38800
formatted as m/d/yyy shows 3/24/2006
formatted as dd/mm/yyy shows24/03/2006

The underlying value is the same
--
Gary's Student


"Marshall Scmidt" wrote:

> I have an import from a finance package that has put a data column into the
> american date format or maybe a general text format. How do i convert to
> dd/mm/yyyy
> --
> Marshall

Format as your regional dates then do data>text to column, click next twice,
under column data format select MDY and click finish


--

Regards,

Peo Sjoblom


"Marshall Scmidt" <[email protected]> wrote in
message news:[email protected]...
>I have an import from a finance package that has put a data column into the
> american date format or maybe a general text format. How do i convert to
> dd/mm/yyyy
> --
> Marshall