Replace "-" with "0"

G

Guest

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!
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

6.00 to this 0600 please 2
SUBSTITUTE(Outward!B5,"-","0")+0 7
One more step in the Formula Please 7
ignore "0" 9
How to check if the values in a range of cells are greater than 0 3
106% to this please 6% 7
IF function says too many nested 1
A Lotto Numbers generator 3

Top