View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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