date conversion

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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.
 
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
 
Back
Top