date conversion

[Jeff]

I am trying to import a file that has dates on it in this
format yy-mm-dd. When excel receives the dates it
converts them to standard mm/dd/yyyy . Unfortunately the
mm shown is actually the yy and the dd shown is the mm and
the yyyy shown is the day.
Example: Import 03-04-24
Result 3/4/2024
Dose anybody have any ideas on how I can fix this.
Thanks in advance.

 

[Sue D]

No sorry Jeff, but I have pretty much the same problem at
the moment. I am trying to put in a bank sort code which
is numbered like ##-##-## and it keeps converting it into
date format but dd/mm/yyyy or mm/dd/yyyy, not sure
which. When I reformat it as text and save it, it looks
fine and then when I re-open the file or convert it into
a csv file, it re-formats it as a date again? Help!! I
am trying to get the data right so that I can import a
file into my database.

Sue D

 

[Andy B]

Jeff

Try this:
=TEXT(B11,"yy/mm/dd")

Andy

 

[jeff]

That did the trick thanks for the help!!!!!!

-----Original Message-----
Jeff

Try this:
=TEXT(B11,"yy/mm/dd")

Andy



.