text after formula

[catherine]

I want to add the text string "feet" after I sum a row of
numbers.

 

[Dan E]

= SUM(A1:A10) & " feet"

Dan E

 

[Peo Sjoblom]

Or if you want it to be a number use custom format

=SUM(A1:A10)

format

General "feet"

 

[Dan E]

I should add it might be usefull to use the TEXT formula to
format your number...

ie:

=TEXT(SUM(F7:F11), "0.000") & " feet"

will give a number with 3 decimal places...

Dan E

 

[Dan E]

That's much better . . .

You can still use the numbers in calc's.

Dan E

 

[May]

=SUM(A1:A3) & " feet"

 

[Guest]

I need to use the value in another equation...I don't
have "feet" as an option under general format nor can I
create a custom one. Is there another way to just use the
value from a cell containing number and text?

Thanks for all your help!

 

[Dan E]

Why can't you create a custom format?

I need to use the value in another equation...I don't
have "feet" as an option under general format nor can I
create a custom one. Is there another way to just use the
value from a cell containing number and text?

Thanks for all your help!

 

[catherine]

I don't know, I have tried everything short of creating a
new template.

 

[Dan E]

Catherine,

Select the cell with the sum in it and hit:
Format -> Cells
Under the Number tab choose Custom as the category
In the custom Type: field enter [General "feet"] without the
square brackets.

Dan E

 

[Guest]

thanks all, it worked great