Hi everyone,

I need to distribute a spreadsheet to my colleagues across Europe and I have
run into an issue that I hope someone has a solution for.

Simply put, a formula like =text(a1,"dd-mmm-yyyy") works fine in a situation
where the Windows Regional settings are English. However, German or Swiss
whomever, call dd-mmm-yyyy something different.

Now Excel "translates" formulas based on the Regional settings but for some
reason, "dd-mmm-yyyy" is seen as a literal and therefore not translated so
the formula results in a #Value.

Short of making the user change their settings to suit the model
(unacceptable) how can I ensure this sort of thing does not happen?

Please note - the formula I am using is an example and not the only one.
Others include =info or =cell etc.

All help appreciated.

Many thanks!
Bony
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."