Information after formula result

  • Thread starter Thread starter Paola
  • Start date Start date
P

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.
 
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.
 
=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
 
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
 
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"


.
Click to expand...
 
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
 
Back
Top