Hello Community,

i need help to create a Formula – i would be very happy if someone can help me here.

I have more then 400 lines and i need to change all of them as below.

020018007615

is the standard but i need this number as below:

020-018007615

Actuall i need to change every line by mysef to mention the  “-” after the first three numbers. 

Is there a possibility to have a Formula here that every number will be shown as xxx-xxxxxxxxx ?

Thank you all for your help!

Jenny

​Hello Community, i need help to create a Formula – i would be very happy if someone can help me here. I have more then 400 lines and i need to change all of them as below. 020018007615is the standard but i need this number as below:020-018007615 Actuall i need to change every line by mysef to mention the  “-” after the first three numbers.  Is there a possibility to have a Formula here that every number will be shown as xxx-xxxxxxxxx ? Thank you all for your help!Jenny   Read More

​