decimal zero in label and textbox of userform
Posted by Lieuwer on November 25, 2001 9:03 PM
When filling a textbox or label in a userform the decimal zero of 123.40 disapears. What can be done to display it? (the number comes from a worksheet and is loaded as a text or caption. This text or caption is not always a number, it can be text as well.).
Posted by Tom Dickinson on November 26, 2001 10:32 PM
TextBox = Format(Range(worksheet reference,"0.00"))
Of course this will mean that a number will appear in this format, no matter how many decimal places it has or doesn't have.
