Text to Number

[Guest]

Hi all,
I need help converting data from text to number in order to export into
Access. The current format is as follows:
1234-0000012345-6 and need to have it as 12340000123456
I looked into other postings but could not find a solution...then again I
might have missed it...
Thanks for the help.

 

[Guest]

=VALUE(SUBSTITUTE(A1,"-","")) will delete the hyphens and convert what's left
to a number. You'll still need to change the format. And beware, you're
nearing the limits of Excel's numeric precision.

 

[Gord Dibben]

Have you tried Edit>Replace

What: -

With: nothing


Gord Dibben MS Excel MVP