Hi Hari,

I thought I'd found this out using the application help but I can't find it
there now!

If you want to learn how to do all the clever stuff with Excel, then I'd
recommend this book: Walkenbach, J. & Underdahl, B (2001) Excel 2002 Bible
published in UK by Hungry Minds

This book covers the format of the custom number formats.

Cheers,

Mark


"Hari Prasadh" wrote:

One doubt from where could I read up stuff which explains the range of
things one can achieve with the custom options.

Like how do you know that 3 "entities" could be written and first one would
apply for positive, second for negative and so on.