How to show month by name

[#1]

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?

[Gysbert_Wassenaar · Accepted solution]

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.

[Vegar]

Try this:

Month(date)

Or

Date(date,'MMM')