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