Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
can you convert baht text back to a number? | Excel Worksheet Functions | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) |