software

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
JanetTry 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 -gt; Values, Operation -gt;
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

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

quot;Daniel CHENquot; wrote:

gt; Try this:
gt; 1) In any cell type number 1
gt; 2) Press Ctrl C to copy the above cell
gt; 3) Select the whole range which contains the text/numbers
gt; 4) Go to menu: Edit/Paste Special, check Paste -gt; Values, Operation -gt;
gt; Multiple
gt;
gt; This will mutiply all cells by 1 and auto convert those text into numbers.
gt;
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt; Free Excel / VBA Training Materials is Available for Download
gt;
gt; =================================
gt; quot;Jittyquot; gt; wrote in message
gt; ...
gt; gt; Hello Experts, I wonder if you can help me again.
gt; gt;
gt; gt; My company uses SAP R3, and information is downloaded from there into
gt; gt; Excel.
gt; gt; I am supposed to do a VLOOKUP to compare material numbers, but the info
gt; gt; from
gt; gt; SAP R3 downloads as text rather than numbers, which means my VLOOKUP will
gt; gt; not
gt; gt; work. I believe there is an easy method of converting text to numbers
gt; gt; using
gt; gt; the =VALUE formula, but I can't get it to work.
gt; gt;
gt; gt; Can anybody please help me? At the moment I have to go into every cell
gt; gt; with
gt; gt; a formula error, and use the 'Convert to Number' option in the formula
gt; gt; error
gt; gt; window.
gt; gt;
gt; gt; Thanks very much for any help.
gt; gt; Regards
gt; gt; Janet
gt; gt;
gt;
gt;
gt;