Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Multiple pages for a formula | Excel Discussion (Misc queries) | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
naming formula | Excel Worksheet Functions | |||
I need to get this answer 8 - 1.2 = 6.2 from a formula | Excel Worksheet Functions | |||
If and (and) formula to allow a zero answer | Excel Worksheet Functions |