| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation for Prices in Cells
Out of all the years I've used Excel I've never used data validation before
and need help. I have a list of part numbers (Col.A), part descriptions (Col.B), and part prices (Col.C). I want to ensure the user enters a valid price in Col. C. It can be any price, but must be numeric. I have Col.C formatted as Accountanting. And ideas? Thanks in Advance! -- Cheers, Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| Validation Data and Looking Up Cells | Excel Worksheet Functions | |||
| Data validation in 3 cells | Excel Programming | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
| How do I compare 4 cells of prices and print the lowest value in . | Excel Worksheet Functions | |||
Threaded Mode
