Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convertig Number to Text - equivelent to single quote
I have a list of item numbers that are sent to me from different sources -
sometimes formatted as number and sometimes formatted as text. The master file I keep for lookup formaula has the items stored as text - with my problem being the VLOOKUP formula expecting the values to match, and is not giving results all the time. To cure the issue I can go to the numeric value and type a single quote inthe cell preceding the number and this converts it to text and the lookups work, but sometimes the list is hundreds of items long, so I am looking for an easier way to do this. Simply highligting the column and formatting all values as text does not do the trick - is there a formula that will work that I can apply to the cells? So far I have not had luck with the TEXt and T formulas. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convertig Number to Text - equivelent to single quote
Copy a blank cell, then highlight your data, right click Paste Special,
select Add then click OK ---------------- mama no teeth "Nathan" wrote: I have a list of item numbers that are sent to me from different sources - sometimes formatted as number and sometimes formatted as text. The master file I keep for lookup formaula has the items stored as text - with my problem being the VLOOKUP formula expecting the values to match, and is not giving results all the time. To cure the issue I can go to the numeric value and type a single quote inthe cell preceding the number and this converts it to text and the lookups work, but sometimes the list is hundreds of items long, so I am looking for an easier way to do this. Simply highligting the column and formatting all values as text does not do the trick - is there a formula that will work that I can apply to the cells? So far I have not had luck with the TEXt and T formulas. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
number range returning a text value | New Users to Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) |