can't change format

[juster21]

I have a column of tax ID numbers in this format...xx-xxxxxxx.
No matter what I try I can't remove the -.
Any ideas??

 

[Jonmo1]

is xx-xxxxxxx what is displayed in the FORMULA BAR when cell is selected?

or do you see xxxxxxxx in formula bar?
If so, it's a custom format that's doing it.

 

[juster21]

the formula bar has xx-xxxxxxx.

 

[Jonmo1]

can you use the find/replace function?

or via formula

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

 

[bryhamm]

and you can't do a search and replace for "-" and replace with nothing?

 

[juster21]

find/replace did not work...but the formula did!!! thanks a million!!