Numeric in Text to convert back to the form of Numeric for VLookup Purposes

  • Thread starter Thread starter achilles
  • Start date Start date
A

achilles

Hi Good Day

I always need to export from Crystal report in excel form, but I dont
know why the account code which is in "Numeric" such as "11001" is
always export as text, and when I want to vlookup from another set of
data, each of them cant recognize each other, is the anyway to convert
the text numenic to purely numeric ??

Btw, the crystal report only offer me to export as MS excel therefore I
cant do convert the text to numeric form ..
 
Hi

Into some free cell enter the number 1. Copy the cell. Select the range with
your text numbers, and then PasteSpecial>Multiply
 
Suppose your account no. is in A1, try this:

=vlookup(value(a1),<range>,......

Hans
 
it work .. thank you very much
Arvi said:
Hi

Into some free cell enter the number 1. Copy the cell. Select the range
with
your text numbers, and then PasteSpecial>Multiply


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"achilles" <[email protected]>
wrote in
message news:[email protected]...
Click to expand...
 
It is work as well .. really thanks for help
flummi said:
Suppose your account no. is in A1, try this:

=vlookup(value(a1),<range>,......

Hans
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

general data convert to numeric. 1
vlookup with numeric and alphanumeric identifiers in lookup_value 1
Extracting Numerals From a Text String? 1
converting text cell to numeric cell 5
text to numeric 3
Calculating numerical month (1 to 12) from text date 4
convert text format to numeric 5
Numeric date to text..formatting question 2

Back
Top