On Thu, 23 May 2013 10:48:48 +0100, _Adrian wrote:


Hi,

My first post here, hope someone can help.

I have created an Excel 2010 spreadsheet that is to be used in various
European countries (I'm in the UK). One of the pilot testers in Austria
(but otherwise using a UK laptop with UK settings) is experiencing the
following issue whereas all other testers under similar conditions
report no fault. I can't explain it...

I have a calculated date based on an input year:
A1=DATE(Current_Year,1,1)
Adjacent to this I have B1=TEXT(A1,"ddd") in order to display Mon or Tue
or Wed etc

This works fine in the version I've sent and recalculates fine. However,
change the Current_Year and the result of the TEXT function becomes ddd
(and not Mon etc)!

Can anyone explain why, and better still, how to fix this!?

Thanks,

Adrian

Let's figure out the cause first.

That kind of error is seen when "ddd" is not a valid notation for "day".
Possibly the user has changed the Control Panel / Windows Regional Settings (NOT the Excel settings), to Austrian; or to German(Austria).