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
 

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

text to numeric 3
Numeric date to text..formatting question 2
Prevent conversion of numeric text string to scientific notation 1
Convert Numbers to Text 4
Columns formatted As Dates Are Exported as a Number to Text 1
Numeric to text conversion 3
Using text values in Pivot Tables 5
how do I convert column labels back to alphabetic from numeric? 3

Back
Top