text or american date format

M

Marshall Scmidt

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
 
G

Gary''s Student

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
 
P

Peo Sjoblom

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