Currency Format Only Certain Info in cell
Thanks.
"Dave Peterson" wrote:
="Prewire "&A1&" $"&text(A2,"#,##0.00")
&CHAR(10)&"Unwired "&B1&" $"&text(B2,"#,##0.00")
Change that format inside the =text() function to something you like.
FormulaQuestioner wrote:
I am working on a formula that I need to have certain numbers in the currency
format:
The formula I have is
="Prewire "&A1&" $"&A2&CHAR(10)&"Unwired "&B1&" $"&B2
I need to have A2 and B2 setup so they will show as 8.90 instead of 8.9. I
have been trying to figure it out in the Custom Cell Field to no avail.
How would I set the cells to do that?
--
Dave Peterson
|