I've searched in posted items with no success.

When I create a custom format like ##-##-## and I type 458586 I get: 45-85-86

But, if the code I enter is C45858 I get C45858, and not C4-58-58 which is what I wanted.

What is the custom format I should creat to get C4-58-58 when I type C45858??

Thanks in advance!!