I've figured out how to put a formula and text in the same cell, thanks
to this group. However, I can't figure out how to format the value of
the cell. For example, I want to create one cell with the following:
The following is what I put in the cell:
="Cost $" & B21*8.
This is the result I get:
I want the value to round to 2 decimal points, but I can't figure out
how to do that. The cell B21 is already in currency form, but the new
value does not show up with a dollar sign. So, I guess I have 2
1. How do I get this dollar sign to show up automatically (being that
the value is based upon another dollar value?)
2. How do I round the value to 2 decimal places?
help is greatly appreciated.