Thread: 2 Data Validations Q
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
  
Posts: 454
Default 2 Data Validations Q
Further tweak to =AND(J10<"",H10=0.01,H10<=40000). How do I limit
the user inputing more than 2 decimal places e.g 1050.125 should not
be allowed




Reply With QuoteReply With Quote