View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default Set Column Negative

Michael Laferriere wrote:
Hi Folks - I know how to convert positive numbers to negative. The multiply
by -1 works well if you have already entered the values. Is there a way to
force negative numbers in a specific column at the time of entry? Thanks.


Would you want to use validation where entry < 0?

Beege