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
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"steshi" <steshi@discussions.microsoft.com> wrote in message
news:C774BC43-E991-4173-AC9D-9F35E845B7C8@microsoft.com...
> 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
That did add the text....thanks. The only thing is that it dropped the
formating. Actually, if I go to the "cell format" the format is what I set
it to be but it dropped the "$" so rather than it displaying " $980.25 per
week", it displays " 980.25 per week" with no dollar sign.
"Paul B" wrote:
> steshi, try this,
>
> =H30/4 & " per week"
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "steshi" <steshi@discussions.microsoft.com> wrote in message
> news:C774BC43-E991-4173-AC9D-9F35E845B7C8@microsoft.com...
> > 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
>
>
>
You could use Custom formatting of the cell
Format>Cells>Number>Custom> $ #.00 "Per Week"
The in your cell just enter =H30/4
This has the advantage, that the value in the cell is still numeric and
can be used in further calculations if required.
--
Regards
Roger Govier
"steshi" <steshi@discussions.microsoft.com> wrote in message
news:F731DA48-C920-4E6E-A127-DDD1E1F28A11@microsoft.com...
> That did add the text....thanks. The only thing is that it dropped
> the
> formating. Actually, if I go to the "cell format" the format is what
> I set
> it to be but it dropped the "$" so rather than it displaying " $980.25
> per
> week", it displays " 980.25 per week" with no dollar sign.
>
> "Paul B" wrote:
>
>> steshi, try this,
>>
>> =H30/4 & " per week"
>>
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from
>> it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>> "steshi" <steshi@discussions.microsoft.com> wrote in message
>> news:C774BC43-E991-4173-AC9D-9F35E845B7C8@microsoft.com...
>> > 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
>>
>>
>>
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" <steshi@discussions.microsoft.com> wrote in message
news:C774BC43-E991-4173-AC9D-9F35E845B7C8@microsoft.com...
>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
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" <steshi@discussions.microsoft.com> wrote in message
> news:C774BC43-E991-4173-AC9D-9F35E845B7C8@microsoft.com...
> >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
>
>
>
Question
Reply
Top
Answer
Notify me of replies