Hi there,

I have a program that exports an Excel with dates in it, and those dates are in 'General' format (which is fine). I use this exported excel in a Macro, and based all the Macro functions on the exact formating of the exported excel.

However, when I manually edit the date in this exported Excel (even putting the cursor in the edit box and not changing anything!) it automatically changed it to the Date format. When I then put that into the Macro it gets everything wrong, so it really needs to stay in General format...

I've tried, in vain, to have a (for example) '19/08/2011' that is in General format, but it seems impossible.

Is there any possible way to do this?

Thanks a lot.