Thanks Jarek, unchecking zero values does the job for what I need.

"Jarek Kujawa" wrote:

Excel 2003

1. Format-Cells-Custom and define an own format like this: # ##0;-#
##0;-
(mind the separator might be , instead of ; as I'm using a national
version of Excel)

2. to make the worksheet more readable you may also hide zeros Tool-
Options-View and uncheck Zero Values

HIH


On 29 Kwi, 10:18, CW wrote:
Hi All,

I have a working formula as follows:
=SUMPRODUCT(('Timelines Data'!B4:B52="Modelling")*('Timelines
Data'!D4:D52<=TODAY())*('Timelines Data'!E4:E52=TODAY()))

This returns the number of projects active in the 'Modelling' phase. The
results table is large and to make it more readable I would like to show '0'
as '-'.

Would it be possible to show how I could build this is or is there an
alternative option.

Thanks
Carol

.