Format problem ( SUM & "text")
 

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

Format problem ( SUM & "text")
 

Hi
Try this:
=TEXT(SUM(A1:A10),"0.00")&" ft2"

Andy.

"Ed" wrote in message
...
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

Format problem ( SUM & "text")
 

=TEXT(SUM(A1:A10,"# ##0,00"" ft2""")

HTH
--
AP


"Ed" a écrit dans le message de news:
...
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

Format problem ( SUM & "text")
 

"Ed" wrote in message
...
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?

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

Format problem ( SUM & "text")
 

=TEXT(SUM(A1:A10),"#,##0.00 ft2")


--
HTH

Bob Phillips

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

"David Biddulph" wrote in message
...
"Ed" wrote in message
...
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?

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

Format problem ( SUM & "text")
 

Thanks! this is exactly what I meant...