I don't think you'll succeed with formatting alone.

But you could use a helper cell:
=if(a1="y",1,0)

You could put this in column B and hide that column, but use B1 for the
subsequent formulas.



billybob wrote:

I need to format a cell so that if I enter an upper case "Y" it displays
the "Y" but the cell thinks the value of the "Y" is "1" so that it can
be added in another function elsewhere. I have tried to use the "IF"
functions but have had no success as of yet. HELP!

--
billybob
------------------------------------------------------------------------
billybob's Profile: http://www.excelforum.com/member.php...o&userid=26610
View this thread: http://www.excelforum.com/showthread...hreadid=398817

--

Dave Peterson