| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
TEXT "ddd" giving #N/A on some machines
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "NxtRow = Cells(Rows.Count," giving me fits | Excel Programming | |||
| "File in Use" notification works on some machines, not on others | Setting up and Configuration of Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| FileCopy Command Giving "Subscript Out of Range" Error Message | Excel Programming | |||
| "Clean Me" Macro is giving "#VALUE!" error in the Notes field. | Excel Programming | |||
Threaded Mode
