Non-US date format in Zoho Sheet

Non-US date format in Zoho Sheet

Hi

I'm a Zoho user from New Zealand where the standard date format is DD/MM as oppose to MM/DD as is common in the US.

I can set the format for existing dates in Zoho Sheet to DD/MM but still have to enter new dates in the US format. I.e. to enter November 4 I have to put 11/4 even if the cell is set to DD/MM/YYYY and immediately re-displays the input as 04/11/2011.

That's pretty confusing and user unfriendly.

Two suggestions:
- could the spreadsheet parse the date entered according to the format set for the given cell?
- can we have a global setting for these things somewhere? I want all dates in all Zoho apps displayed by default as DD/MM/YYYY without explicitly setting it everywhere.

That'd be awesome!

Thanks :)