Basically, the country locale you are in might be the one.

Go to File - SpreadSheet Settings. Select the correct Locale.

Eg, US is mm/dd/yyyy whereas UK is dd/mm/yyyy

Then you try again to change the format.

Hope this helps.

Salim Bashar
Singapore.

On Wednesday, July 22, 2009 at 12:45:02 AM UTC+8, NEHicks wrote:
I have a column of dates (Jul 2,2009) that I want to format as 7/2/09. I can
change the formatting to anything I want and the cells never change. What's
wrong?