| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Linear Mode
