Information after formula result

[Paola]

I have a simple formula that provides the square footage
of a building. A want the result to read 88sf. The
formula is A1*B1=? and I want to add the sq after my
number. Is it possible?

EXAMPLE:

a = 20
b = 40
c = A*B and after I press enter I want the result in cell
c to read: 80sf.

Thank you.

 

[Andy B]

Hi

You could to it like this:
=A1*B1&" sf"
but this leaves the cell as text - meaning you can't do calculations on the
result.

 

[Michael Malinsky]

=A1*B1&"sf"

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Mihir]

Hi!

Please select the coloumns where you want to add "sf",
right click - select format cells - custom and paste
" _-* #,##0 [$sf-42D]_-;-* #,##0 [$sf-42D]_-;_-* "-"
[$sf-42D]_-;_-@_- " (without ")in the "type field"

There are other ways as well ofcourse.

Hope this helps

Regards..
Mihir

 

[Paola]

Thank you

-----Original Message-----
Your best bet is to amend the number format of the cell.

Select the result cells, then click on Format, Cells and select the tab for numbers.

Select custom format and type the following in the box:

#,##0 "sf";-#,##0 "sf";0 "sf"


.

 

[Gord Dibben]

Paola

Format>Cells>Custom

00"sf"

Gord Dibben Excel MVP

 

[Dana DeLouis]

Instead of "sf", you could give it a more mathematical look with the
following idea.
Make a custom format similar to:

#,###.## ft²

The last character is a small raised 2, which is entered by holding
Alt+0178.
Don't know if this will come out ok in this posting.

800 ft²

HTH
Dana DeLouis