Niek Otten wrote:
Unfortunately you don't get what you want; you get a format that is not one
of your defaults and is not what you type. It gets worse if you type 5/13;
Excel displays May-13 but the formula bar shows it means May 1 2015!

Not sure whyt you're getting 2015 but when I type 5/13 it displays 13-May
in the cell and 5/13/2005 in the formula bar.

gls858