On Wed, 6 Jul 2005 22:58:02 -0700, kiddie
wrote:

formula to change 1 to a / and .50 to O and add up correctly


Since you are wanting to change the display of a cell, you might be better off
changing the format:

Select the cells.

Format/Cells/Number Custom Type: [=0.5]O;[=1]\/;General


--ron