naming an answer in a formula

T

T-bart

This is probably a piece of cake so excuse my ignorance. I cannot seem to
figure out how to label an answer in a formula for example: I want to add
numbers that are square feet and label the answer "square feet" eg.
1000+2000=3000 square feet. How do I write the formula to include sq ft with
the answer. Thanks
 
N

Native

Couple ways....

1) have the 1000 and 2000 in other cells A1 and A2 and write the
equation as =A1+A2&" square feet"
2) on the cell where the answer is, go to Format Cells, go to Custom
along the side selections, then on the General modify the Type: field
to 'General "square feet"' (no single quote around the whole phrase,
just the quotes around square feet
 
Top