Format problem ( SUM & "text")

[Ed]

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

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

Andy.

"Ed" <Ed@discussions.microsoft.com> wrote in message
news:3E69BF50-DFC2-401D-8BD4-6781BFBC4D31@microsoft.com...
> 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

[David Biddulph]

"Ed" <Ed@discussions.microsoft.com> wrote in message
news:3E69BF50-DFC2-401D-8BD4-6781BFBC4D31@microsoft.com...
> 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

[Ardus Petus]

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

HTH
--
AP


"Ed" <Ed@discussions.microsoft.com> a écrit dans le message de news:
3E69BF50-DFC2-401D-8BD4-6781BFBC4D31@microsoft.com...
> 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

[Bob Phillips]

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


--
HTH

Bob Phillips

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

"David Biddulph" <david@biddulph.org.uk> wrote in message
news:x7qdnWwh_4o2BBTZRVny3w@bt.com...
> "Ed" <Ed@discussions.microsoft.com> wrote in message
> news:3E69BF50-DFC2-401D-8BD4-6781BFBC4D31@microsoft.com...
> > 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
>
>

[Ed]

Thanks! this is exactly what I meant...