If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Formula error due to different languages (#N/A)

January 11th, 2019, 22:19

Hello,

I am running into a problem due to language settings.
We have a sheet with various formulas using things like "=VLOOKUP($A5&TEXT($B5,"uu:mm"),source_data,E$1+3,FALSE)"

The "uu:mm" is the standard dutch reference for what in english would be "hh:mm". I have Excel standard in English. So when I so anything in the sheet, the formula suddenly does not understand what uu:mm is, and generates #N/A
If I manually change all the "uu:mm" to "hh:mm", the sheet works fine, but my collegues with Dutch excel get the error.

Is there a workaround/bypass to allow me (with English excel) and my collegues (with Dutch excel) to work?