View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default Replace "-" with "0"

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.