TextBox value includes + sign?

[Big Lar]

With this line of UserForm code:
TextBox10.Value = Format(WS.Cells(iRow, 10).Value, "$ #.00")
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Negative values include the minus sign
<o> </o>
How can I display the plus sign if value is a positive number?

 

[Richard Schollar]

Use this:

TextBox10.Value = Format(WS.Cells(iRow, 10).Value, "$+#.00;$-#.00")

 

[Big Lar]

Excellent!
Thank you.