CODEWITHSUNDEEP
excelexcel-formula
Michi
Michi

Reputation: 5481

Date-Formatting in TEXT formula independent from used language in Excel does not work anymore after update of Office365

With reference to this question I have been using the below solution to have a date-format in a TEXT formula independent from the language that is used in Excel:

Excel:

  |       A      |       B        |
--|--------------|----------------|-
1 |  2021-11-01  |   #BLOCKED!    |
2 |              |                |

Formula in B1:

B1 = TEXT(A2,REPT(@Time_Global_Year,4)&"-"&REPT(@Time_Global_Month,2)&"-"&REPT(@Time_Global_Day,2))

Name Manager:

Time_Global_Year = INDEX(GET.WORKSPACE(37),19)
Time_Global_Month = INDEX(GET.WORKSPACE(37),20)
Time_Global_Day = INDEX(GET.WORKSPACE(37),21)

However, after Office365 version has been updated I am suddenly getting the error #BLOCKED! instead of a date in Cell B1.

Do you know what I need to change to make it work again?

Upvotes: 1

Views: 61

Answers (1)

Michi
Michi

Reputation: 5481

As mentioned in the comments enabling Excel 4.0 macros solved the problem:

enter image description here

Upvotes: 1

Related Questions