close

I want to set the custom formatting to the above said format

hi, Shiji !

gt; I want to set the custom formatting to the above said format

you will 'see' the leading commas [but]...
you may want to give it a try: -gt; #\,##\,##0.00

[perhaps] a 'better' way: -gt; [gt;=100000]#\,##\,##0.00;#,##0.00

hth,
hector.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()