Date time formats keep reverting back to default

[cd]

I have a column of dates that I assigned a custom format to.
When the data in this column gets refreshed from a data base query the
format keeps reverting back to the default format.

How can I stop this behavior?

 

[Anne Troy]

I doubt you can. Sounds like the format is coming over with it. Why don't
you record a macro, and give yourself a toolbar button to run. Start
recording, select the column, change the format, hit Ctrl+Home and stop
recording.
For reference:
http://www.officearticles.com/excel/record_a_macro_in_microsoft_excel.htm
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_applications.htm
Good luck!
************
Anne Troy
www.OfficeArticles.com