| 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 |
| 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) | |||
Threaded Mode
