Format problem ( SUM & "text")

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a cell in which I have as a formula

=SUM(A1:A10)&" ft2"

and I have a similar formula in other cells, some have as a result 2 decimal
places, others have 5 others 6 and so on, and I can't find a way to make them
all have 2, any ideas?

,thanks
 
Ed said:
Hello, I have a cell in which I have as a formula

=SUM(A1:A10)&" ft2"

and I have a similar formula in other cells, some have as a result 2
decimal
places, others have 5 others 6 and so on, and I can't find a way to make
them
all have 2, any ideas?
Click to expand...

If you want the SUM to have 2 decimal places, try
=TEXT(SUM(A1:A10),"0.00")&" ft2"
 
=TEXT(SUM(A1:A10),"#,##0.00 ft2")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top