| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting numbers to text
Is there a more efficient way to convert a number to a text value other than
using the =trim(number) formula? I use vlookup often...and it doesn't recognize a text entry of say "6001" with the number 6001 unless I convet the number to a text value with the formula =trim(6001) and then converting the formula to a value. Please advise as to whether there is a better way. Thanks, Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting numbers to text
Try using a double unary (--) in the formula
=VLOOKUP(--A1,M1:N20,2,False) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "bobs" wrote in message ... Is there a more efficient way to convert a number to a text value other than using the =trim(number) formula? I use vlookup often...and it doesn't recognize a text entry of say "6001" with the number 6001 unless I convet the number to a text value with the formula =trim(6001) and then converting the formula to a value. Please advise as to whether there is a better way. Thanks, Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
| Convert text numbers to numbers | Excel Worksheet Functions | |||
| converting numbers to text | New Users to Excel | |||
| about converting numbers to text. | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Hybrid Mode
