Posted to microsoft.public.excel.worksheet.functions
|
|
Convert Text to Numbers
Daniel
Brilliant - and exactly what I need. Thank you very much :-)
Janet
"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
=================================
"Jitty" wrote in message
...
Hello Experts, I wonder if you can help me again.
My company uses SAP R3, and information is downloaded from there into
Excel.
I am supposed to do a VLOOKUP to compare material numbers, but the info
from
SAP R3 downloads as text rather than numbers, which means my VLOOKUP will
not
work. I believe there is an easy method of converting text to numbers
using
the =VALUE formula, but I can't get it to work.
Can anybody please help me? At the moment I have to go into every cell
with
a formula error, and use the 'Convert to Number' option in the formula
error
window.
Thanks very much for any help.
Regards
Janet
|