Hard values to convert to number

  • Thread starter Guilherme Loretti
  • Start date
G

Guilherme Loretti

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?
 
D

Daniel CHEN

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

Dominic

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

HTH
 
D

dlw

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?
 
Top