Forum Discussion
Date format while export in excel
Hi All, I am facing an issue while exporting data in to excel. In report I am able to trim timestamp of a datetime field by using format() and also able to change the format as I like. But o...
Thanks very much for looking into this and your reply.
If I use FORMAT (A1, "DD-MM-YYYY") it is displayed as expected in the report. Thats fine but once I exported the data into excel and opening the excel, it always showing as DD/MM/YYYY. Can this data not get saved in the excel as DD-MM-YYYY format?
That is more of an Excel behaviour. It sees the data and then deciedes itself on what visual format it believes you will want. You would either need to disable auto-format or append an apostrophe ( ' ) at the start of the data for excel to leave it alone.
https://www.journalofaccountancy.com/issues/2016/dec/how-to-turn-off-excel-auto-format.html