View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Courtney Courtney is offline
external usenet poster
 
Posts: 22
Default Data Validation - allowing only negative numbers or converting

I'm building a model where end-users must input expenses and revenues. In
the expense section I'd like to ensure that numbers are entered as negatives,
or if they are entered as positives build a formula in the data validation
section that would automatically convert them to negative numbers. Any idea
on how to do this?

Any insight would be appreciated.

Thanks!