Remove dashes from Numbers

Question

I've looked through the site and not been able to fix this.

I have spreadsheets where the social security number has dashes (000-00-0000) and other which do not.

It is preferred to have all data WITHOUT the dashes.  I've tried to reformat the cell's but it will not bulk remove the dashes which requires me to go in manually to do this.

Any idea how I can update each cell that has the dashes and remove them?

Thanks for all your help!  It has assisted me greatly to get daily work completed.

Answer 1

Apply custom formatting to your range using nine 0s

000000000

and then use Ctrl-H and replace the character dash   -      with nothing.

Note that if you are using these values anywhere else and there is a leading 0, that will disappear unless your use the TEXT function, like

=TEXT(A2,"000000000")