Is there a way to make sure that dates and numbers are shown in a specific format when exporting a record list to excel via Electronic reporting?
Whatever I try in the Format tab of the Format designer or the excel template file, my exports keep looking like this:
Format designer:
Hi Jeremy,
many thanks for your reply. This indeed does the trick!
Trying the above, at first I got the following error:
"The configured expression cannot be used as the binding of the current format element to a data source as this expression returns value of the data type 'String' that is beyond the scope of data types that are supported by the current format element of type 'Cell'."
Because the DATEFORMAT formula returns a string value, I changed the Cell's Data type in the format tab from Date to String. Although this gives an error in the format designer too, I am able to successfully run the report.
Regards
Xavier
Hi Xavier,
Have you tried using a formula to format the text? Select the cell in the designer and click Edit Formula. Try the DateFormat function. Something like this should work for you:
DATEFORMAT(@.TransactionDate, "dd/MM/yyyy")
Thanks,
Jeremy Driscoll
Microsoft Support Engineer
Hi Ludwig,
Thank you. This is what I also thought, I formatted the cell (even tried the whole columns) but that did not work. After that I set up the excel template as a Table and did the formatting, also without a result unfortunately.
The cells in the exported excel file are all of type "General" (except for the headings!). So for the moment this remains a mystery.
Best regards
Hello XavierF,
The issue is in your excel template.
Can you format the cell in the excel template as a date field?
Once that is done, upload and attach your new template and you should be ok.
Best regards,
Ludwig
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 665 User Group Leader
Martin Dráb 595 Most Valuable Professional
Yng Lih 558
