Excellent and thankyou very much.

"Domenic" wrote:

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!

In article ,
Steved wrote:

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.