View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
donwb donwb is offline
external usenet poster
 
Posts: 81
Default 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