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?

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" <GuilhermeLoretti@discussions.microsoft.com> wrote in
message news:4815E137-E2C0-46F2-A77D-1C74BBD7BD19@microsoft.com...
>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?

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?

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Guilherme Loretti" <GuilhermeLoretti@discussions.microsoft.com> wrote in
message news:4815E137-E2C0-46F2-A77D-1C74BBD7BD19@microsoft.com...
>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?

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" <GuilhermeLoretti@discussions.microsoft.com> wrote in
> message news:4815E137-E2C0-46F2-A77D-1C74BBD7BD19@microsoft.com...
> >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?
>
>
>