VBA to have listbox row source show as 2 decimals

Hi All

I have the following code which populates my listbox from a row source.
Column A is single digit
Column B is String
Column C is number
Column D is number

The format in the row reference is correct. How can i get Columns C & D to show as two decimals instead of 1 i.e
150.50 shows as 150.5

Please Login or Register  to view this content.

Maybe liike this

Please Login or Register  to view this content.

Kind regards
Leo

Hi Leo

Thanks for input. Throws an error Subscript out of range at following line of Code. Also notice that somehow Columns A and B won't be populated.
Any ideas

Please Login or Register  to view this content.

Hi Leo

Attached is a workbook...Sheets("1") is row source and Sheet2 is snapshot of userform as is with my existing code.

for the moment
change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

think this will do
otherwise I see later this day
Cheers
Leo

Please Login or Register  to view this content.

Result in sheet3

Hi Leo

Your sample book works great. I get a runtime error 1004 Application defined or object defined error on the following line of code:

Please Login or Register  to view this content.

Leo...Got it figured out. Thanks for your code. Changes made as follows:
THIS

Please Login or Register  to view this content.

TO THIS

Please Login or Register  to view this content.

Now i want to know wy if i run it works, see pic

and you need this .value extra
any one know ???

Could it be that I have 34 UserForms each with there own TextBox6.Value

maybe depending from where code is called.

It's called from 3 different userforms...View Table Open table and New Table.