Hi JE McGimpsey & Pete_UK,

Thank both for your help on this!

At the moment I seem to be getting a #value! error when I try either
solution. Any ideas? Do I need to set something else up / change
something?

To help me figure out what's going on, could you please let me know
what the following are/do:

Choose
Sign
Text

Are they functions which Excel will recognise, or are they things that
I need to set a UDF for?

Also, JE McGimpsey - thanks for the info about the UDF. I had no idea
that you could declare your own functions in Excel.... how cool is
that! :)

Cheers
Kessa


--
kessa
------------------------------------------------------------------------
kessa's Profile: http://www.excelforum.com/member.php...o&userid=32080
View this thread: http://www.excelforum.com/showthread...hreadid=518338