Colon in formula is not working

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

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


    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 ?

  • 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.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels