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
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,
VBA 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)
Thanks in advance,