View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Help with a custom label?

What do you use the $255 data that comes from B22 for? Why can't you just
type in Customers in that cell rather than the =b22 cell reference.

"wishmyr" wrote:

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 around Customers but i
am unable to get it to work.

here is a sample of what i'm working on

$255 $20 $21 $22
10 (2,145) (1,845) (1,545)
12 (1,905) (1,545) (1,185)
14 (1,665) (1,245) (825)
16 (1,425) (945) (465)
18 (1,185) (645) (105)

I need the 255 to read customers in stead of reading $255( that cells
formula is =b22)
Can you help?
Tammy