![]() |
Help with a custom label?
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 |
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 |
Help with a custom label?
=b22 equals the $255 that i need to use as part of the formula i need to use
for the two variable data table. My boss wants it to read Customers in stead of the $255 but still have the formula calculate the numbers in the data table, all I know is I have to use the quotation marks around the label name in the type text box but no idea what i'm doing wrong. "tim m" wrote: 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 |
All times are GMT +1. The time now is 07:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com