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

Publisher 2019 Format Picture window size too large to display OK button 0
How to change the date format from import link? 1
Date format 9
Word OLE to check spelling in text box 1
Word doc keeps changing to ALL CAPS 0
How does one change the font name with VBA? 0
How to add day to PWA 2016 date format? 0
How to change the year digit? 4

Top