Currency Format Only Certain Info in cell

  • Thread starter FormulaQuestioner
  • Start date
F

FormulaQuestioner

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?
 
D

Dave Peterson

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

FormulaQuestioner

Thanks.

Dave Peterson said:
="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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top