G Guest Jul 17, 2007 #1 I tried custom format but it would not remove my hypens. I need that format for an export
G Guest Jul 17, 2007 #2 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
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
G Guest Jul 17, 2007 #3 BJ you are the BEST, oh my gosh, it worked perfectly. Maybe I won't go home with a headache today! Thanks Again
BJ you are the BEST, oh my gosh, it worked perfectly. Maybe I won't go home with a headache today! Thanks Again
