dates automatically formatted wrong

B

bigajosepi

Hi. I'm copying dates and other data from a text file which has them
formatted like:
YYYY-MM-DD
and excel reformats them as soon as i copy them into a format like:
dd/mm/yyyy

taking away zeros where they are not needed. is there any way for me to
copy and paste the dates and keep them looking exactly the same.
thanks!
 
Top