View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steshi steshi is offline
external usenet poster
 
Posts: 3
Default 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