Smart detector and re-format

[danial]

Hi All,

Today I have a ploblem about exporting data to excel
Firstly I can export data to excel by vba coding.
but when xcel display my data for number value in format ####.00
realy, I can coding for change that to expected format but
there are many formats which I need to change.
e.g. format date and time, format date only, format currency

I don't know that who have any ways to detect value or property from access and change to expect format