No Dashes, please?

[Patrick]

how do i use the value of a cell without the dashes?

For example

range(A1) = "123456-4434"

i want to use that number in an equasion as "1234564434"

thanks

 

[JE McGimpsey]

One way:

=SUBSTITUTE(A1,"-","")+1

 

[Frank Kabel]

Hi
try
ret_var=CDbl(Replace(range("A1").value,"-",""))

 

[Bob Phillips]

=SUBSTITUTE(A1,"-","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)