Colon in formula is not working

Colon in formula is not working

Posted by: manwinder.kaur on 13 November 2022, 6:09 pm EST

• 

  manwinder.kaur

  • Post Options:
  • Link
    Copy

  Posted 13 November 2022, 6:09 pm EST - Updated 13 November 2022, 6:15 pm EST

  Hello,

  We are using following piece of code to create custom culture. Here we are using semicolon as a list separator. So, when I use semicolon in a formula (For example: =SUM(C5;C6)) on spread, this works fine and but when I use colon in the same formula (=SUM(C5:C6)) on spread, this results in an error #Value!.

  I want to use both semicolon ; and colon : as list separator. Is there a way to pass multiple separators as list separator ?
  
  

  

  1170×562 66.4 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 15 November 2022, 3:18 pm EST

  Hello Manwinder,

  Multiple separators cannot currently be supplied as a list separator. Excel has a regulation that we adhere to, and that policy prohibits passing multiple list separators for a culture.

  Regards,

  Ankit