(*/15/*) * was wild card in dos does it still apply I am going to try it.
Guess this old mind is getting clouded
Thanks again

"Gary''s Student" wrote:

Say we want the number 123 entered in cell B9 on 12/25/2009

In B9 enter:

=IF(TODAY()=DATEVALUE("12/25/2009"),123,"")
--
Gary''s Student - gsnu200830


"Curt" wrote:

is it possible to have excel 2000 enter a set amount into a cell on a set
date. I have never attemped to do this as yet. I have a sheet and can reserve
a cell for input. This is a balance sheet so amount entered would be part of
the sum of the column. Am aware that sometimes copied amount don't sum.
I am relucant to have this done by user off a menu as people do forget.
Hope I have not muddied the waters to much.
Thanks.