I need a formula that will look at one cell G7 and if it is a 1, 2,3, 4, 5,
6, 7, or a then I need it to display a 1.

The formula I am using is this:

=IF(G7="1","1",IF(G7="2","1",IF(G7="3","1",IF(G7=" 4","1",IF(G7="5","1",IF(G7="6","1",IF(G7="A","1"," 0")))))))

All the cells are formatted as general text. The formula is working when it
sees "a" but not any of the numbers? Any ideas on how I can make the whole
thing work?