Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In excel data sheet date stored in dd/mm/yyyy format,when i am trying to put in listbox it is showing as number . I want to show by month name wise.
Can anyone suggest how to do that?
In a listbox you can set the format on the Number tab of the properties screen. Check override document settings, select date and modify the format pattern. DD-MMM-YYYY will show a three letter month: 12-Apr-2012. MMMM will show the full month name.
In a listbox you can set the format on the Number tab of the properties screen. Check override document settings, select date and modify the format pattern. DD-MMM-YYYY will show a three letter month: 12-Apr-2012. MMMM will show the full month name.