Thread: How can I convert a group of numbers to a group of letters?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I convert a group of numbers to a group of letters?
A VLOOKUP table would probably do the trick.

See Excel help on VLOOKUP or go to Debra Dalgleish's site for "real" help.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 15:42:02 -0700, CarlG
wrote:

My store uses a retail price "code" wherein a price like 99 in expressed as a
code like "PP"--exchanging the number digits 1-0 as letters.
Is there a function to do this automatically?

Reply With QuoteReply With Quote