Hard values to convert to number
 

I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?

Hard values to convert to number
 

Try this:
1) In any cell type number 1
2) Press Ctrl+C to copy the above cell
3) Select the whole range which contains the text/numbers
4) Go to menu: Edit/Paste Special, check Paste - Values, Operation -
Multiple

This will mutiply all cells by 1 and auto convert those text into numbers.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Guilherme Loretti" wrote in
message ...
I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?

Hard values to convert to number
 

Maybe try putting a 1 in a blank cell. Copy that cell, the select your values
and click edit:Paste Special:Multiply?

HTH

"Guilherme Loretti" wrote:

I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?

Hard values to convert to number
 

You can't, excel can only use 15 digits, are you really calculating with
these numbers?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Guilherme Loretti" wrote in
message ...
I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?

Hard values to convert to number
 

what kind of "numbers" are they? just 16 digit numbers in a text field. If
you go =value(a1) excel will change it to scientific notation, whateverE+16
Is that not happening?

"Daniel CHEN" wrote:

Try this:
1) In any cell type number 1
2) Press Ctrl+C to copy the above cell
3) Select the whole range which contains the text/numbers
4) Go to menu: Edit/Paste Special, check Paste - Values, Operation -
Multiple

This will mutiply all cells by 1 and auto convert those text into numbers.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Guilherme Loretti" wrote in
message ...
I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?