Display number as letter?

[EvergreenSara]

I want to have a spreadsheet where whenever I type in "10", it is actually displayed as "A"

Is this possible? Help!

 

[lenze]

Hi and welcome to the board.

Select the cells where you wish this to apply.
Choose Format >Cells
Select Custom for category.
For Type, enter
[=10]"A";
Click OK

HTH
lenze