Hoping someone can help as I am struggling to understand when Sharepoint exports to excel why is my lookup value columns exporting as text (should be date value), plus the formatting is different. Also having similar issue with a number field and it bringing over multiple decimal places after the number as 0.
I have validated my sharepoint is English US and my windows is the same. I can't edit the column that has the lookup value to be date format in my list view.
What I need is just US Date format 1/3/2021, column to be date format when I export, 2nd Number column to read just as 123 (not 123.000)
-1st image is of the list view with the lookup date (displays correct, and number) -2nd image is of the export to excel -Last image is the list view of the data source exported to excel with correct formatting
This has me completely stopped on a department project-frustrating as I have about 15-20 columns I have to do this on and add to other lists/views.









]