| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUBSTITUTE(Outward!B5,"-","0")+0
SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#2
|
|||
|
|||
|
Hi!
Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#3
|
|||
|
|||
|
=0&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0,1)
-- Vasant "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#4
|
|||
|
|||
|
"Biff" wrote in message
... The above will return a text string. If you want a numeric number Hi Biff: I know it's late, but are there non-text strings and non-numeric numbers? <vbg Just kidding! Regards, Vasant "Biff" wrote in message ... Hi! Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#5
|
|||
|
|||
|
A former co-worker once asked:
Is that the number Oh or the letter zero? It still brings smiles. Vasant Nanavati wrote: "Biff" wrote in message ... The above will return a text string. If you want a numeric number Hi Biff: I know it's late, but are there non-text strings and non-numeric numbers? <vbg Just kidding! Regards, Vasant "Biff" wrote in message ... Hi! Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. -- Dave Peterson |
|
#6
|
|||
|
|||
|
Hmmm......
I don't get it ! Biff "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... "Biff" wrote in message ... The above will return a text string. If you want a numeric number Hi Biff: I know it's late, but are there non-text strings and non-numeric numbers? <vbg Just kidding! Regards, Vasant "Biff" wrote in message ... Hi! Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#7
|
|||
|
|||
|
Thankyou
"Biff" wrote: Hi! Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
|
#8
|
|||
|
|||
|
Sorry, only my late-night sense of humor! Just ignore me <g.
-- Vasant "Biff" wrote in message ... Hmmm...... I don't get it ! Biff "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... "Biff" wrote in message ... The above will return a text string. If you want a numeric number Hi Biff: I know it's late, but are there non-text strings and non-numeric numbers? <vbg Just kidding! Regards, Vasant "Biff" wrote in message ... Hi! Try this: Is 0110001 a numeric number or a text string? ="0"&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0) The above will return a text string. If you want a numeric number: =SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0)*1 Format the cell as CUSTOM - 0000000 Biff "Steved" wrote in message ... SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
