text with numeric value

  • Thread starter Thread starter Boone
  • Start date Start date
B

Boone

I have searched for a while to find a way to make a cell
display a certain value, that isn't a number, but contains
a numeric value that can be used as input for another
cell. Ex: Cell (A2) displays: "Days in a week", and if
cell (B2) contains: =A2, then it displays the number 7.
Thanks for your help
 
I was really set on having the aforementioned
functionality. I have achieved as much by putting the
numeric value into a cell and then creating a custom
number format with the specified text, in this case you
can do what I stated, but there is a limit of about 300
custom number formats you can make. It is supposed to
be "limited by available memory", but my system has plenty
of available memory. Just wondering if there was another
way. Thank you for your time and help
 
Back
Top