English (UK) Settings Problem?
 

I have a workbook for English (United States). A customer is in the U.K. and
has his regional settings set to U.K. and office language set to English
(United States). The customer uses our VB6 program to export data into our
workbook.

Now, this workbook has a column with dates. The problem is that the dates
show up in the format dd-mm-yyyy. However the formatting show in the
Format::Cells option shows it set to "Custom, mmm-yyyy". The user has
formula's that need this mmm-yyyy format. I have tried many times to get this
to show the correct format, but still don't have it working.

The best solution I've had so far was to create a macro that went through
each cell in the column and called Format( "mmm-yyyy"). And, although this
solution works on my PC, it does not apparently work for the customer.

Does anyone have any ideas of how to fix such a thing?

English (UK) Settings Problem?
 

See your post in .misc. There you state you are getting the results '###' which
means your column is not wide enough.

--
Regards,
Fred


"blyvan" wrote in message
...
I have a workbook for English (United States). A customer is in the U.K. and
has his regional settings set to U.K. and office language set to English
(United States). The customer uses our VB6 program to export data into our
workbook.

Now, this workbook has a column with dates. The problem is that the dates
show up in the format dd-mm-yyyy. However the formatting show in the
Format::Cells option shows it set to "Custom, mmm-yyyy". The user has
formula's that need this mmm-yyyy format. I have tried many times to get this
to show the correct format, but still don't have it working.

The best solution I've had so far was to create a macro that went through
each cell in the column and called Format( "mmm-yyyy"). And, although this
solution works on my PC, it does not apparently work for the customer.

Does anyone have any ideas of how to fix such a thing?