View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikeebabe Mikeebabe is offline
external usenet poster
 
Posts: 1
Default format a cell when I type 10 it will multiply 10 by .585

I'm trying to format a cell in a way where the number I input will
automatically be multiplied by a number predetermined by me.
ie: I format cell a1 so it's contents is multiplied by .585
when I input the number 10 in cell a1 it will display as 5.85