Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 191
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 789
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Listbox Max Columns steve Excel Programming 2 March 13th 08 08:24 PM
Alignment and format in listbox columns Jim Rech Excel Programming 4 August 25th 05 12:54 PM
Alignment and format in listbox columns Tom Ogilvy Excel Programming 0 August 24th 05 01:05 PM
Q: find range, listbox - format and fit columns Mark[_17_] Excel Programming 0 June 8th 04 12:41 PM
Format columns in a ListBox? Soniya Excel Programming 1 October 12th 03 11:40 AM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"