| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Format a List Box
I have a 2 column ListBox 1st dates 2nd text. ListBox is
populated from an array, itself populated from a 2 column range of cells in the WorkSheet. The 1st worksheet (dates) column is formatted in the English (GB) format "31/02/04" However the ListBox shows the dates in the American longer format "2/31/2004" (without the leading zero for the month) How do I format the ListBox to reproduce the dates as they were in the original source data. Any suggestions would be greatly appreciated. Don Bowyer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format List | Excel Discussion (Misc queries) | |||
| Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
| How to format two repeating XML elements w/o getting list of list | Excel Discussion (Misc queries) | |||
| format control of a list box | Excel Worksheet Functions | |||
| List Box format | Excel Programming | |||
Threaded Mode
