The separator is related to the language settings.

Rule of thumb: of the decimal separator is a . (dot) then the parameter separator is a , (comma)

So most non-english languages have the , (comma) as decimal separator and need the ; (semi-colon) as parameter separator

  • When you say TEXT=([Date], "mmmm"), you are actually referring to: =TEXT([Date],"mmmm"), no? I would recommend to try the formulas in MS Excel first, for me is easier to debug than using SP itself.
    – cubanGuy
    Aug 12, 2014 at 20:04
  • Yes sorry, I will edit the question. It's just the regional settings difference that blow my mind. Is it ',' in EU and ';' in US or something like that?
    – Funnybear
    Aug 13, 2014 at 8:26
  • 1
    As far as I know it is "," everywhere. This Link may help with the formulas.
    – cubanGuy
    Aug 14, 2014 at 1:37


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.