There is no setting for this. Basically, you get what you are seeing.

You would have to load the useform with code rather than use the row source
to do the formatting - so you would format the text strings and then put
them in the list. This doesn't include Rich Text Formatting.

--
Regards,
Tom Ogilvy


Jim C. wrote in message
...
i have a listbox on a userform whose rowsource is a named
range and is multicoulmn. a column on the worksheet is
formatted as accounting. i would like to have the same
column in the listbox have the same accounting format. is
there a way to do this? I would also like to have other
columns formatted differently but if i can be pointed in
the right direction i can figure out the rest... thank
you...