excel workbook changes into time format

[enxocoebl]

Hi i have a excel workbook about 200kb in size
i have about 8 tables and a macro in it
sometimes when i open it the default format changes to time format
and i get values like this 00:00:00
i know this is not new.. I ve searched the internet but havent found a fix.
I have recorded a macro that will do the re-formatting for me.
Is there a fix?

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?650012-Default-formatting-changes-to-time-format

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).