I'm trying to use the TEXT formula to insert commas into large numbers.
For example:
Cell S2 = 6000000000 (displays as 6,000,000,000 with formatting)
if Cell U2 = CONCATENATE(S2) does not show commas.
if Cell U2 = CONCATENATE(S2,TEXT(S85,"000,000,000")) number displays properly.
if S2 = 35,000, formula does not display properly: (000,035,000)
Does anyone know of a formula to make the number formatting appear correctly for all numbers, large and small?
Thanks in advance for any help! Hopefully I explained that clearly.
For example:
Cell S2 = 6000000000 (displays as 6,000,000,000 with formatting)
if Cell U2 = CONCATENATE(S2) does not show commas.
if Cell U2 = CONCATENATE(S2,TEXT(S85,"000,000,000")) number displays properly.
if S2 = 35,000, formula does not display properly: (000,035,000)
Does anyone know of a formula to make the number formatting appear correctly for all numbers, large and small?
Thanks in advance for any help! Hopefully I explained that clearly.