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?