Hi Capot,
The @functions in excel are included to allow a degree of compatibility with Lotus 1-2-3. There is no guarantee that they will be retained or that they will function consistently. However, your post did remind me that cell formatting may be a better and cleaner way forward.
Excel custom formatting (select cell - right click - select format - click number - select custom) has the following structure:
positive number format;negative number format;zero format;text format
eg:
* #,##0;-* #,##0;"";@
will display a blank cell for any zero value without having to use any formulae.
HTH
EG
Last edited by ExGrunt; 17th Jun 2015 at 05:48.