Hi Cath

embed your current formula in a IF function e.g.
=IF(A1="","",current_formula)
or
=IF(ISBLANK(A1),"",current_formula)
or
=IF(ISERROR(current_formula),"",current_formula)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"cath_cw" wrote in message
...
i need to set a sheet up as a template and until the data is entred, the
#value! shows in the cell -- i want it to be blank until each person is
able
to input their data