Currenct Formatting Advice

[ipbr21054]

Hi,
I have the code shown below,

Can you advise the correct way to write it because if my value is 4 i actually see 4$0.00

Removing the 0.00 in the code then i see 4$

I cant get it to be shown like $4

Me.txtCost = Sheets("LPM").Cells(i, "E").Value & "$0.00"

Thanks

 

[Scott Huish]

Me.txtCost = Format(Sheets("LPM").Cells(i, "E").Value,"$0.00")

 

[ipbr21054]

Cheers that worked fine.

Would you mind taking a look at this,https://www.mrexcel.com/forum/excel-questions/1070289-prefill-txt-box-drop-down-list-code.html
Post #5

Ive nearly got it but not quite.

Thanks