How do I combine text and a calculation in the same field?
That did it. Thank you so much. To remember that first option, I will need
to analyze it more so that I understand all the logic. The second option for
setting up a custom format is way easier to understand and establish. I am
very excited to have learned this. Thanks again.
"Dana DeLouis" wrote:
If you wish to limit the number of decimal places display, perhaps one of a
few ways:
=TEXT(H30/4,"$ #.00 ""Per Week""")
Another common option is to add a custom format to the cell:
#.## " Per Week"
This allows you to continue to use the cell as a value, and not as a text
string.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"steshi" wrote in message
...
I am trying to do a calculation and have text follow that in the same
field.
An example might be as follows : =(H30/4) per week
I want the calculation to be there, be a space and then the words "per
week"
in the same field. I do not have room for another column just for those
two
words.
If anyone can help, I would appreciate it very much. Thanks, Stephanie
|