I want to set the custom formatting to the above said format
H Héctor Miguel Jan 11, 2006 #2 hi, Shiji ! I want to set the custom formatting to the above said format Click to expand... you will 'see' the leading commas [but]... you may want to give it a try: -> #\,##\,##0.00 [perhaps] a 'better' way: -> [>=100000]#\,##\,##0.00;#,##0.00 hth, hector.
hi, Shiji ! I want to set the custom formatting to the above said format Click to expand... you will 'see' the leading commas [but]... you may want to give it a try: -> #\,##\,##0.00 [perhaps] a 'better' way: -> [>=100000]#\,##\,##0.00;#,##0.00 hth, hector.
