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.

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

Have you tried Edit>Replace

What: -

With: nothing


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 09:35:02 -0700, FJinSA <[email protected]>
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.