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.