vba, concatenate & strings

[padadof2]

I have a worksheet that I use to create a proposal from a bid sheet. I am pulling cell values from the bid sheet (shB) and putting into the proposal sheet (shP) I am using a loop to go through the bid sheet. I have this code

shP.Cells(k, 4).Value = "Approx. " & shB.Cells(j, 3) & " " & shB.Cells(j, 4) & " @ $" & Round(shB.Cells(j, 11), 2) & " / " & shB.Cells(j, 4)

which works and gives me "Approx. 150 SF @ $500 / SF" ,but I would like to have it show "Approx. 150 SF @ $500.00 / SF" How can I get those two decimal points to show up?
Thanks in advance,

 

[Fluff]

How about

shP.Cells(k, 4).Value = "Approx. " & shB.Cells(j, 3) & " " & shB.Cells(j, 4) & " @ $" & Format(Round(shB.Cells(j, 11), 2),"0.00") & " / " & shB.Cells(j, 4)

 

[padadof2]

How about

shP.Cells(k, 4).Value = "Approx. " & shB.Cells(j, 3) & " " & shB.Cells(j, 4) & " @ $" & Format(Round(shB.Cells(j, 11), 2),"0.00") & " / " & shB.Cells(j, 4)

Thank you!! Works like a champ.

 

[Fluff]

You're welcome & thanks for the feedback.