Currency Format Only Certain Info in cell
 

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?

Currency Format Only Certain Info in cell
 

="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

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