View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default entering a number and having a word appear in excel

Hi,

It's possible but only with code and I think you've simplified the problem
for the purposes of asking the question. If you explain in detail a more
complete list of substitutions then someone will help.

Mike

"kdill" wrote:

Can anyone tell me, in microsoft excel, how do i type a number in a cell and
have a word appear in that same cell instead of the number. Is this even
possible.
For example: if i type in 7131 i want the word drafting to appear.