Date format in transaction table

[First Last]

Currently, the date format in transaction table is in ISO format

yyyy-MM-dd'T'HH:mm:ss.SSSXXX
2007-01-01T00:00:00.000-08:00

Someone told me that Excel will not recognize it on import.

Any suggestion on that best, most portable format that can be recognized automatically by Excel?

[First Last]

We will just use date only version for now: yyyy-MM-dd