View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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