| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data entry validation
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data entry validation
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry + Validation | Excel Discussion (Misc queries) | |||
| How to design data entry validation? | Excel Discussion (Misc queries) | |||
| Macro Data Entry Validation | Excel Worksheet Functions | |||
| Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
| Data Entry Validation in Excel | Excel Programming | |||
Linear Mode
