The only way I can think of is to use the option "show zero values"; then in
the area where zeros are not to be shown forma the cell with something like
#;#,"" to hide zeros
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"IanC" wrote in message
...
I know it is possible to show zero values in a sheet by ticking "zero
values" in options, but I have a situation where zero values should only
be shown in certain areas of the sheet.

I've tried setting formatting to text and this displays zero values
entered, but it plays havoc with the data validation (Decimal greater than
or equal to 0).

Is there any way I can retain operation of the data validation, but still
display zero values in a specific range?

--
Ian
--