format listbox columns
 

I have a listbox with 7 columns. How do i format the last 5 columns as
currency with the negative amounts in parenthesis and red?
Thanks

format listbox columns
 

Hi
Do it on the worksheet before you pull it into the listbox. If not on
the worksheet, do it in a hidden worksheet then lift to listbox
regards
Paul

On Apr 28, 3:02*pm, ranswrt wrote:
I have a listbox with 7 columns. *How do i format the last 5 columns as
currency with the negative amounts in parenthesis and red?
Thanks