The display will come out correct if you type in 11/23/2009 if you have
formatted the cell Y/M/D. Your operating system is in charge of how dates are
entered and not XL. If you want to change how dates are entered then

Start - Setting - Control Panel - Regional and Language - Date | yyyy/m/d

Note that this changes date entry for your entire system and not just XL...
--
HTH...

Jim Thomlinson


"Shannan" wrote:

But i want it to display 09-11-23 and so i am typing in 09-11-23 but excel is
automatically changing it to 23-11-09 when i've set the formatting to "date"
and "01-03-14".

"Jim Thomlinson" wrote:

The format only changes how the date is displayed and not how it should be
entered. To enter Nov 23, 2009 type

11/23/2003

The formatting will flip around how the date is displayed...
--
HTH...

Jim Thomlinson


"Shannan" wrote:

Hi,
I am trying to format all the date columns in my spreadsheet to show up at
Y/M/D. I've set the formatting to "Date" and then "01-03-14". However, if i
type 09-11-23, meaning november 23rd 2009, it keeps changing it to 23-11-09.
If i click on the cell, it displays 09/11/2023 in the fx bar at the top of
the screen. Is there a way to get around this without having to type in
2009-11-23?

Thanks. Shannan.