I am copying dates from a website formatted in MMM-DD (e.g. Sep-12).
However, when I copy the dates into excel, it reads it as DD-MM (e.g. Sep-12
is copied as Dec-09). If I copy dates which cannot be transposed (such as
Oct-16) then it copies correctly as Oct-16.

Is there a way to
a) Copy the native dates into excel (e.g. Sept-12 as Sept-12)
b) Copy dates such that Excel does not interpret them as dates (e.g. Sept-12
is "Sept-12" not 09/12/2007 in the formula bar)
c) Easily transpose month and day (e.g. convert Dec-09 to Sept-12)

Thanks,
Noah