MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.