Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 06, 06:48 AM posted to microsoft.public.excel.misc
achilles
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes


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 ..


--
achilles
------------------------------------------------------------------------
achilles's Profile: http://www.excelforum.com/member.php...o&userid=31210
View this thread: http://www.excelforum.com/showthread...hreadid=508827


  #2   Report Post  
Old February 6th 06, 07:44 AM posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"achilles" wrote in
message ...

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 ..


--
achilles
------------------------------------------------------------------------
achilles's Profile:
http://www.excelforum.com/member.php...o&userid=31210
View this thread: http://www.excelforum.com/showthread...hreadid=508827



  #3   Report Post  
Old February 6th 06, 07:47 AM posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes

Suppose your account no. is in A1, try this:

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

Hans

  #4   Report Post  
Old February 6th 06, 08:04 AM posted to microsoft.public.excel.misc
achilles
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes


it work .. thank you very much
Arvi Laanemets Wrote:
Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"achilles"
wrote in
message ...

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 ..


--
achilles

------------------------------------------------------------------------
achilles's Profile:
http://www.excelforum.com/member.php...o&userid=31210
View this thread:

http://www.excelforum.com/showthread...hreadid=508827



--
achilles
------------------------------------------------------------------------
achilles's Profile: http://www.excelforum.com/member.php...o&userid=31210
View this thread: http://www.excelforum.com/showthread...hreadid=508827

  #5   Report Post  
Old February 6th 06, 08:05 AM posted to microsoft.public.excel.misc
achilles
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes


It is work as well .. really thanks for help
flummi Wrote:
Suppose your account no. is in A1, try this:

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

Hans



--
achilles
------------------------------------------------------------------------
achilles's Profile: http://www.excelforum.com/member.php...o&userid=31210
View this thread: http://www.excelforum.com/showthread...hreadid=508827



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I convert text string into a cell reference Dave Davis Excel Discussion (Misc queries) 3 June 10th 08 09:38 PM
Changing cell format - for example text to numeric sjrku Excel Discussion (Misc queries) 3 December 30th 05 11:40 PM
can you convert baht text back to a number? maginator Excel Worksheet Functions 0 December 2nd 05 04:26 PM
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 04:51 PM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017