Question with Formulas and Formatting

[thescream80]

Hello,

I am trying to create a formula that will display 2 numbers in one cell.
The formula I Created works but is there a way to add a comma for the numbers in the second part of the formula? Or is there a way to make this cleaner?

I2694 = Total of numbers


=TEXT(I2694, "0,000")&" / "&SUM(I110:I2693)

Thank you for ANY help!

 

[jtakw]

Hi,

You can just do the same to the second part as in the first part of your formula, like:

=TEXT(I2694,"0,000")&" / "&TEXT(SUM(I110:I2693),"0,000")

 

[thescream80]

Thank you!

 

[jtakw]

You're welcome.