View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnWFUBMC JohnWFUBMC is offline
external usenet poster
 
Posts: 1
Default Custom Formating Cells

I want to format a cell so that when I type a number into that cell it will
take the absolute value of that number and then multiple it by 1000. Is
there anyway to do this without generating a formula in a new cell?