How to change the date format?

[Eric]

In cell A1, it is 10-Apr-2010, which is saturday. If I change the format
type into dddd, then it will show Saturday.
Does anyone have any suggestions on how to change the format into
Traditional Chinese "星期六"? what is the format coding?
Thanks in advance for any suggestions
Eric

 

[Garreth Lombard]

Hi Eric,

Go to Tools>Options and select the "General" Tab then select the font your
want at "standard font".

The font you need is 'simsun', so please be sure to download it if you have
not got it installed on your machine.

Download the font here >
http://cooltext.com/Download-Font-新宋体+Sim+Sun

HtH

 

[Eric]

I try the default font to be 'simsum', but date fails to display chinese font
saturday "星期六". do you have any more suggestions?
Thanks in advance for any suggestions
Eric