Change format ###-###-#### to ##########
 

I tried custom format but it would not remove my hypens. I need that format
for an export

Change format ###-###-#### to ##########
 

your data may be text
try =substitute(entry,"-","")

if the hyphons do not go away, they may be non breaking hyphons
copy one of the hyphons and put into the substitute() function

"jmjt" wrote:

I tried custom format but it would not remove my hypens. I need that format
for an export

Change format ###-###-#### to ##########
 

BJ you are the BEST, oh my gosh, it worked perfectly. Maybe I won't go home
with a headache today! Thanks Again

"bj" wrote:

your data may be text
try =substitute(entry,"-","")

if the hyphons do not go away, they may be non breaking hyphons
copy one of the hyphons and put into the substitute() function

"jmjt" wrote:

I tried custom format but it would not remove my hypens. I need that format
for an export