|Subject:||use symbols in a formula|
|Posted by:||kit (anonymo…@discussions.microsoft.com)|
|Date:||Wed, 15 Oct 2003|
Doing an autonmated worksheet for schoolkids.
I have a worksheet with division sums etc set out that
they complete. If correct I want to insert a smiley if
wrong unsmiley next to their answer.
Did this with an If function with the inserted value as a
wing ding for smiley etc. However in the worksheet cell a
black dot is added whatevever wing ding character is added.
I assume this is to do with the cell holding the formula
being formatted for wingdings?
If I use a word in arial the IF formula works OK.
Anyone know of a workaround, or a more elegant solution?