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

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

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