Ryan,

Try something like this:

TextBox6.Value = Format(Cells(290, 3), "##0.00%")

--
Hope that helps.

Vergel Adriano


"ryguy7272" wrote:

I am using a few simple lines of code in a TextBox such as:

TextBox6.Value = Cells(290, 3)

This takes a value from a cell, and displays it on my UserForm. The only
problem is that it is always displayed in the TextBox in a format such as .2,
or .493, or some such thing. I am trying to get the TextBox to display the
value in percentage format, perhaps even with two decimal places. How can I
do this? I tried the Macro Recorder, and I looked on several web sites;
havent found the answer yet. Any help would be greatly appreciated!

Regards,
Ryan---


--
RyGuy