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