VBA number formatting

[dave8]

I am pulling a cell value in VBA formatted as percentage (0.00%). The value I have in the cell, for example is, 5.13%. I'm taking this value and displaying it in a label on my form. For example, txtTax.Caption = Format(TaxRate, "0.000"). The variable TaxRate is a string. But the value displayed on the label shows as: 0.0513. How to display this value as it is on the cell, which is 5.13 ?. I don't care about the percent sign, I just want it to be displayed as such, 5.13.

 

[pgc01]

Hi

Try:

txtTax.Caption = Format(Val(TaxRate) * 100, "0.00")

 

[dave8]

That is what I'm looking for. Thanks.

 

[mikerickson]

TextBox1.Text = Mid(Format(Range("A1").Value, "0.00 %"), 2)

 

[dave8]

Okay, that's good too. But Pcg01 had a better, simpler way handling it.