i have a spreadsheet with two columns containing text data, one column
containing date data, and ten columns containing either number or currency
data. currently i only have 100 rows with data.
my goal is when i enter data in a row NOT to have blank text and date cells
and number and currency cells to have a value equal or greater than zero.
is that possible in excel?

Try using the data validation tool. Data >> Validation

There you can set what data is allowed where.

"angie" wrote:

> i have a spreadsheet with two columns containing text data, one column
> containing date data, and ten columns containing either number or currency
> data. currently i only have 100 rows with data.
> my goal is when i enter data in a row NOT to have blank text and date cells
> and number and currency cells to have a value equal or greater than zero.
> is that possible in excel?