I want to get and A to count as a 1 in Excel

  • Thread starter Thread starter dclayton
  • Start date Start date
D

dclayton

i am using excel 2000 and i am useing 35 times 35 cells. everything is just
going to be a one or a zero, but I really need to be able to just type an A
and that count exactly the same as a one would, but I can't type all A's. If
anyone could help I would appreciate it.
 
dclayton said:
i am using excel 2000 and i am useing 35 times 35 cells. everything is just
going to be a one or a zero, but I really need to be able to just type an A
and that count exactly the same as a one would, but I can't type all A's. If
anyone could help I would appreciate it.
Click to expand...

Feels like I just typed this a few minutes ago...

You can make the number 1 display as the letter A. Use this as a custom number
format:

[=1]"A";0

Then you can just SUM() the range to get a total.
 
Back
Top