NumberFormat problems

I'm working with the VBA code behind an Excel report. The report has two entry points: Auto_open and another subroutine which is called by an application. Both entry points are basically indentical.

In one of the data date fields, we're using a Numberformat of "ddd dd". Oddly, sometimes instead of a date (e.g. "Mon 03") it just displays "ddd dd" in the field instead.

We thought that maybe it related to the fact that our client resides in Italy and uses different regional settings. Alternatively, we tried "ggg gg" for giourno, and equivalent Italien format string. We got the same results; sometimes it displayed properly (e.g. "lun 03"), but then sometimes displayed "ggg gg" instead.

Also, it appears that dependant on the way the report is opened (from a directory, using Auto_open, or from the application, using the other entry point), the result is different -- either "ggg gg" or the correctly formatted date.

So, first of all, my question is: why would Excel display the NumberFormat format string instead of the value?

After I understand that, I might be able to proceed.

Any help would be appreciated![

Try using NumberFormatLocal instead of NumberFormat.



This will also compensate for the Italian clients...