| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
general data convert to numeric.
if i have a value that is exported into excel and shows as general format,
how can i convert to numeric in order to do V-lookups. or is there a way to do v-lookups off general formatting. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
general data convert to numeric.
Hi,
VLOOKUP handles text and numbers so if the numbers are text then enclose the lookup value in quotes =VLOOKUP("5",A1:B5,2,FALSE) or You should be able to convert the text to numbers by putting a 1 in a cell and copying it. Select the text numbers and then EDIT|Paste special - select Multiply OK Mike "Paul" wrote: if i have a value that is exported into excel and shows as general format, how can i convert to numeric in order to do V-lookups. or is there a way to do v-lookups off general formatting. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dates mm/dd/yy to general and still look the same | Excel Discussion (Misc queries) | |||
| How to convert data in General Format cells to dates | Excel Discussion (Misc queries) | |||
| how do I convert numeric data to words? | Excel Discussion (Misc queries) | |||
| How do I convert numeric data to string format (without VBA)? | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Linear Mode
