Posted to microsoft.public.excel.programming

donwb

external usenet poster

Posts: 81

How to format ListBox columns

How can I format a Listbox column containing numbers to include
2 decimal points including zeros and thousands separators-
eg the source data is formatted to read 1,234.20 but
this is reproduced in the ListBox column as 1234.2 and
1,234.00 as just 1234
Also , how can I set the width of a column containing text
to fit the widest entry.
Any help would be appreciated.
donwb

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
format listbox columns	ranswrt	Excel Programming	1	April 28th 08 03:39 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 10:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us