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.