B
Bony Pony
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
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