Text to Number
 

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.

Text to Number
 

=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.

"FJinSA" wrote:

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.

Text to Number
 

Have you tried EditReplace

What: -

With: nothing


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 09:35:02 -0700, FJinSA
wrote:

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.