Hi All,
I am using Borland C++ application (An exe application) to get data form
the Database and populating data to Excel with some formating.

In order to format a cell in the excel as date, I am using
Cell.OlePropertySet("NumberFormat", "dd-mmm-yyyy");

It is working fine with US locale setting. When a user with
Dutch(Netherlands) locale uses the same application, then the date displays
something like "06-jan-YYYY". The reason because Excel understands year only
if it is j in Dutch(Netherlands). ie
Cell.OlePropertySet("NumberFormat", "dd-mmm-jjjj");

Now my question is, how can I make it work across all country users?. Please
let me know.

Thanks in advance.

With Regs
Venkat.