View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Star
 
Posts: n/a
Default When I type a constant number I want another number to appear.

I am working with a large budget but repetive numbers. Instead of typing
large numbers, I would like for a small constant number i.e."9", I would like
the formula to calculate it as 30,000. That way 30,000 will be subtracted
instead of 9. Is this possible?