Replace "-" with "0"

S

Steved

Hello from Steved

I have a formula =Inward!B5

ok it gets the value 1-100-1
Can I please add to above formula to change the - to 0
which will give me 1010001.

Thankyou.
 
D

Domenic

Try...

=SUBSTITUTE(Inward!B5,"-","0")

....which will return the number as a text value. If you want to return
it as a numeric value, try the following instead...

=SUBSTITUTE(Inward!B5,"-","0")+0

Hope this helps!
 
S

Steved

Excellent and thankyou very much.

Domenic said:
Try...

=SUBSTITUTE(Inward!B5,"-","0")

....which will return the number as a text value. If you want to return
it as a numeric value, try the following instead...

=SUBSTITUTE(Inward!B5,"-","0")+0

Hope this helps!
Click to expand...
 
Top