| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display numerical code
How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display numerical code
On Fri, 22 Dec 2006 16:56:00 -0800, catwoman
wrote: How do I make a phrase like "cherry bed" display as a numerical code like "0042" once it is entered into the spreadsheet? Construct a table with the equivalences, and use one of the LOOKUP functions. --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display numerical code
This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red.........if you want the cell itself to convert over to 0042 when you type in cherry bed, that would take change-event VBA........... Vaya con Dios, Chuck, CABGx3 "catwoman" wrote in message ... How do I make a phrase like "cherry bed" display as a numerical code like "0042" once it is entered into the spreadsheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display numerical code
"CLR" wrote:
This formula , if put in the next (or any) cell will display 0042 if a1 contains cherry red Chuck, think you forgot to paste the formula ? <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display numerical code
Lol............sorry, it was past my sleepy-time............thanks for
catching it Max........ here's the formula, depending on how it's spelled <g =IF(A1="cherry bed","0042","") ....and of course a VLOOKUP could be used instead if there were many "phrases". Merry Christmas to all............ Vaya con Dios, Chuck, CABGx3 "Max" wrote in message ... "CLR" wrote: This formula , if put in the next (or any) cell will display 0042 if a1 contains cherry red Chuck, think you forgot to paste the formula ? <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell value not recognized by code. | Excel Discussion (Misc queries) | |||
| Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
| t-distribution puzzle in Excel | Excel Discussion (Misc queries) | |||
| How to display weeknumber with year code | Excel Worksheet Functions | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Hybrid Mode
