Formatting a formula within a cell
 

I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.

Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas

Formatting a formula within a cell
 

http://www.j-walk.com/ss/excel/usertips/tip037.htm

try the tips on this site

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Nancee Vee" escreveu:

I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.

Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas

Formatting a formula within a cell
 

The formula below would concatenate a dollar value in A1 to text value in
B1, with a space between the two:

TEXT(A1,"$0,###.00")&" "&B1
--
Kevin Backmann


"Nancee Vee" wrote:

I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.

Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas

Formatting a formula within a cell
 

Col A Col B Col C
0.6 4 =TEXT(A1,"$0.00")&" per "&B1&" ounces"

result is
0.6 4 $0.60 per 4 ounces

--
Allllen


"Nancee Vee" wrote:

I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.

Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas

Formatting a formula within a cell
 

=TEXT(A1+A2,"$.00")&" per 3 ounces "&TEXT(A3+A4,"$.00")&" per 4 ounces"

Vaya con Dios,
Chuck, CABGx3




"Nancee Vee" wrote:

I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.

Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas