I use a high precision Excel add-on that can give me a number with more that the usual 15 digits that Microsoft allows. Some have 50 or more digits, but they are in text form and have no commas.

I would like to have a macro to put in the commas in the normal correct places for a number, but retain it as text.

Greg G:

When I have this number:

1219326319731290961687

it can only be displayed (or used) as text. If I copy and paste it as a number in a cell, Excel changes it to this:

1219326319731290000000

and is not useful to me. I tried your formula but it returned #NUM!

(My add-on gives all of a long number properly up to 1500 digits - but no commas.)

I can work with it as a number, even in text form but afterward I would like to display it for viewers as:

1,219,326,319,731,290,961,687

A function in my personal workbook would help considerably. Thanks for your efforts.