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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com