Convert characters to numbers

**Dryclean** · 04-09-2010, 10:29 AM

I have a set of numbers in column E that is not numbers and I want to convert them to numbers
I know it is a copy then paste special

for some reason I can't upload an example but the forlula is A1&B1 in coulmn E
ex.. a1=3 b1=5 A1&B1 = in E1=35
but e5 is not a number that I can do other things with and need to convert it to a number

thanks

**martindwilson** · 04-09-2010, 10:31 AM

=(a1&b1)+0

**Dryclean** · 04-09-2010, 10:52 AM

WOW
that was toooooo simple
thanks

**Dryclean** · 04-09-2010, 10:59 AM

While I got you her
is excel in office 2007 faster in computing than 2003
also is excell in office 2007 a 64 bit and or 32 bit or do you have to buy the 64 bit