software

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 quot;Numericquot; such as quot;11001quot; 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 ..--
achilles
------------------------------------------------------------------------
achilles's Profile: www.excelforum.com/member.php...oamp;userid=31210
View this thread: www.excelforum.com/showthread...hreadid=508827Hi

Into some free cell enter the number 1. Copy the cell. Select the range with
your text numbers, and then PasteSpecialgt;Multiply--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;achillesquot; gt; wrote in
message ...
gt;
gt; Hi Good Day
gt;
gt; I always need to export from Crystal report in excel form, but I dont
gt; know why the account code which is in quot;Numericquot; such as quot;11001quot; is
gt; always export as text, and when I want to vlookup from another set of
gt; data, each of them cant recognize each other, is the anyway to convert
gt; the text numenic to purely numeric ??
gt;
gt; Btw, the crystal report only offer me to export as MS excel therefore I
gt; cant do convert the text to numeric form ..
gt;
gt;
gt; --
gt; achilles
gt; ------------------------------------------------------------------------
gt; achilles's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31210
gt; View this thread: www.excelforum.com/showthread...hreadid=508827
gt;
Suppose your account no. is in A1, try this:

=vlookup(value(a1),lt;rangegt;,......

Hans
it work .. thank you very much
Arvi Laanemets Wrote:
gt; Hi
gt;
gt; Into some free cell enter the number 1. Copy the cell. Select the range
gt; with
gt; your text numbers, and then PasteSpecialgt;Multiply
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;achillesquot; gt;
gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi Good Day
gt; gt;
gt; gt; I always need to export from Crystal report in excel form, but I
gt; dont
gt; gt; know why the account code which is in quot;Numericquot; such as quot;11001quot; is
gt; gt; always export as text, and when I want to vlookup from another set
gt; of
gt; gt; data, each of them cant recognize each other, is the anyway to
gt; convert
gt; gt; the text numenic to purely numeric ??
gt; gt;
gt; gt; Btw, the crystal report only offer me to export as MS excel therefore
gt; I
gt; gt; cant do convert the text to numeric form ..
gt; gt;
gt; gt;
gt; gt; --
gt; gt; achilles
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; achilles's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31210
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=508827
gt; gt;--
achilles
------------------------------------------------------------------------
achilles's Profile: www.excelforum.com/member.php...oamp;userid=31210
View this thread: www.excelforum.com/showthread...hreadid=508827
It is work as well .. really thanks for help
flummi Wrote:
gt; Suppose your account no. is in A1, try this:
gt;
gt; =vlookup(value(a1),lt;rangegt;,......
gt;
gt; Hans--
achilles
------------------------------------------------------------------------
achilles's Profile: www.excelforum.com/member.php...oamp;userid=31210
View this thread: www.excelforum.com/showthread...hreadid=508827