Thread: custom label
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default custom label

Hi,

do you have a table with the corresp name for the numbers ? like a chart
of accounts?

if yes,
use

=vlookup(b22,yourtable,2,false)

hth
regards from Brazil
Marcelo

"wishmyr" escreveu:

I want to replace the default format for cell d18 with a custom label of
"Customers", I know i need to use the quotation marks but i am unable to get
it to work. right now my cell as a formula =b22 and it displays 255 I want
255 to read Customes instead of the number, can you help?