Formatting returned value in TextBox
 

I am trying to return a value as actual currency. I would like it t
be constant 2 digits. When I use the round feature, it eliminates th
zeros

How do I hold 2 digits constant.

I already am placing the $ in front

--
Message posted from http://www.ExcelForum.com

Formatting returned value in TextBox
 

just use

Textbox1.Text = Format(Textbox1.Text, "$#,##0.00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"jpendegraft " wrote in message
...
I am trying to return a value as actual currency. I would like it to
be constant 2 digits. When I use the round feature, it eliminates the
zeros

How do I hold 2 digits constant.

I already am placing the $ in front.


---
Message posted from http://www.ExcelForum.com/