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.
全站熱搜