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

hi, Scott !

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

hth,
hector.

Hi Hector

Thank You.

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

Scott

"Héctor Miguel" wrote:

hi, Scott !

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

hth,
hector.

Scott Hi,

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

Joco (London)

"Scott" wrote:

Hi Hector

Thank You.

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

Scott

"Héctor Miguel" wrote:

hi, Scott !

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

hth,
hector.

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