format *loval date on excel download to blank

[beckhamrryyaann]

When downloading a grid to excel, if the date is loval, then it is as '1900-01-01'.
How can I make this show just a blank?

[beckhamrryyaann]

Here is a snip shot of what I am referring too.
image.png?

[Johnny Major]

Thank you for letting us know about this. It appears the issue occurs when Excel is used alongside Legacy Excel. If you stop using Legacy Excel, the issue should not occur. However, we will investigate the problem with Legacy Excel.

[beckhamrryyaann]

Thanks Johnny, I did not realize I had Legacy Excel turned on. I unchecked and it looks correct now.