Excel appears to not have this (unless I missed it), but we're getting demand for it. And since we try to match Excel for the cell formatting syntax, I'd like to add this in in a way that makes sense.
So any suggestions on how to specify that you want a short/medium/long date/time/datetime formatted in the local layout? In other words I can spec so that in the US I get mm/dd/yy and in Germany yyyy mm dd.
thanks - dave
Actually, you can use the <strong>asterisk</strong> in the <strong>Cell Format menu</strong> to choose you cell to display depending on the current system regional settings.
For instance :
*06/30/2011 would display differently depending on your system regional settings :
<li>06/30/2011 for US or UK (for instance)</li>
<li>30/06/2011 for France (for instance)</li>
See here for more information.
Select the column/row or cell you want to format:
right button > Format cells > Custom > Type
There is some examples in the box below, some examples are:
d-mmm-yy -> The single d stands for day of month, without leading zeros dd-mm-yyyy yyyy-mm-dd d/mmm/-yy -> mmm stands for name of the month dd/mm/yyyy -> You can also specify the separator yyyy/mm/dd
And so on.