PDA

View Full Version : Solved: Number format issue in multicolumn listbox



Digita
01-05-2009, 04:02 PM
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
01-05-2009, 04:21 PM
On the spreadsheet, in the cells that display the percentage, change the formula to something like this: "=TEXT(C2/B2,"#0.0%")".

Digita
01-05-2009, 04:54 PM
Brilliant. Thanks Nate for your quick response.