Solved: Number format issue in multicolumn listbox

[Digita]

Happy New Year,

Hope you all had a good break. I have a userform with a listbox linking to a worksheet range with 4 columns of data. The figures in 1 of the columns in % format. However, when these numbers are populated into the listbox their format is lost. How do I retain the number format of that particular column when shown in the listbox?

Thanks in advance.

Regards


kp

PS: I attached a sample file for your reference.

[nst1107]

On the spreadsheet, in the cells that display the percentage, change the formula to something like this: "=TEXT(C2/B2,"#0.0%")".

[Digita]

Brilliant. Thanks Nate for your quick response.