View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default cell to stay same

I want the cell to always be a negative, I misunderstood what was asked me.
Thanks,

"Pammy" wrote:

If I enter a 2 in a cell, I want it to always show as a -2.
Anytime I type 2, if comes in as -2. Is there a way to do this?