How to change the date format?

E

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date format 8
Conditional format using dddd 3
How to change the default format for date? 3
How do i get th,nd,st,rd to display in Excel 7
How to change the year digit? 4
How to convert text into different format? 2
Footer date format 2
Default date format (with shortcut keys) 2

Top