Customize Date Report when exporting the data to excel format

[fluffyvampirekitten]

Currently , I have a form that shows the data.
All the date format display this kind of format " 12/17/1974"


But when I export it to excel format


The date is displayed as "17-Dec-74".


However, when i double click on the cell ,it will show "12/17/1974"....



I want the date to displayed in excel -> "17-Dec-1974" or "dd-mmm-yyyy"
Any ideas how can i change the date format when manually formatting the date in excel .

[ranman256]

Excel tends to do its own thing, esp with dates, or numbers.
You could try, in the query, convert it to string, CSTR(format([date],"mm/dd/yyyy"))
excel may keep it that way.
if not, then youd have to, in excel, format the column.
Excel is finicky.