How to change the date format?
 

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

How to change the date format?
 

Hi Eric,

Go to ToolsOptions 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-%E...%BD%93+Sim+Sun

HtH


--

Thank you and Regards

Garreth Lombard


"Eric" wrote:

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

How to change the date format?
 

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

"Garreth Lombard" wrote:

Hi Eric,

Go to ToolsOptions 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-%E...%BD%93+Sim+Sun

HtH


--

Thank you and Regards

Garreth Lombard


"Eric" wrote:

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