I would like to have a a cell that has the value 1,2,3 ... or 10 but it will show some text - but when I use the cell value in formulas it should use the numbers!

For example:

- Cell A1 displays a word
`Apple`

but has a value of 1. - Cell B1 displays a word
`Orange`

but has a value of 2. - Cell C1 will have a formula
`=A1+B1`

, but would display a value of 3.