Getting desperate...need direction!
Posted by Darcy Guineay on January 20, 2002 9:29 AM
I wrote earlier this week about a problem I have and I thank Juan Pablo G.for writing back, but it still was not the answer I was looking for.
Here is the problem:
I am making schedules using different symbols in different cells. When I print out the spreadsheet it has to contain the symbols, however I need the symbols to equate to numeric values.
----- = 1 and --X-- = .5
A1 B1 C1 D1 E1 F1
----- ----- --X-- ----- =sum(A1:D1)
The answer to F1 is 3.5
When it prints out it will look like this
Does anyone have any idea how this can be done or at least point me in the right direction?
Darcy from Honolulu, Hawaii USA