How do I format the number -123456789 as -12,34,56,789?

[Rick Rothstein \(MVP - VB\)]

Select Format Cells, click on Number in the Category list, set Decimal
Places to 0 and click on the first item in the Negative Numbers list (which
should be -1,234).

Rick

 

[Héctor Miguel]

hi, Scott !

try with the following custom number format:
[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;#,##0

hth,
hector.

 

[Scott]

Hi Hector

Thank You.

The solution offered does not work for negative numbers. Can you please help?

Scott

 

[Joco]

Scott Hi,

In format cells>custom create the following
##","##","##","###
it should display + or - the way you require

Joco (London)

Hi Hector

Thank You.

The solution offered does not work for negative numbers. Can you please help?

Scott

hi, Scott !

try with the following custom number format:
[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;#,##0

hth,
hector.

 

[Héctor Miguel]

hi, Scott !

The solution offered does not work for negative numbers. Can you please help?

with Joco's proposal you will see *extra* commas if number is less than 9 digits

for negative numbers try with the following custom number format:
[<-9999999]-##\,##\,##\,##0;[<-99999]-##\,##\,##0;#,##0

[however] you won't be able to mix positive/negative number usin only one format :-(

you might want to give a try an extra cell/column and ws-functions [i.e.]
assuming the number in 'A1':

=text(a1,rept("##\,",match(len(abs(a1)),{3;4;6;8})-1)&"##0")

hth,
hector.

try with the following custom number format:
[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;#,##0