Emily
07-26-2008, 08:34 PM
Recently I found someone use below formula to change calendar to Chinese Lunar Calendar in Excel 2007 ( some words are in Chinese Characters), but some date cannot be changed.
=TEXT(A1,"[$-130000]yy年m月"&IF(LEN(--TEXT(A1,"[$-130000]dd"))=1,"初","")&"d")
It is similar to the self defined date format [$-404] use in Tai Wan Excel Version. Anyone know where I can find the description for format [$-404] and [$-130000] ?
Thanks
Emily
Cross Post:
http://www.mrexcel.com/forum/showthread.php?p=1637075#post1637075
=TEXT(A1,"[$-130000]yy年m月"&IF(LEN(--TEXT(A1,"[$-130000]dd"))=1,"初","")&"d")
It is similar to the self defined date format [$-404] use in Tai Wan Excel Version. Anyone know where I can find the description for format [$-404] and [$-130000] ?
Thanks
Emily
Cross Post:
http://www.mrexcel.com/forum/showthread.php?p=1637075#post1637075