Text to Number

F

FJinSA

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

bpeltzer

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