Thread: How do you format a cell to automatically multiply entry times 2?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default How do you format a cell to automatically multiply entry times 2?
Hi,

Only if you write a VBA macro. And then the issue would be which cells do
you want the macro to run for? For example if you enter a date, Excel thinks
its a number so would you really want to multiply a date by 2.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"HL Charts" wrote:

I want to be able to have a set of cells be automatically multiplied times 2.
For exampls, if I type in 2 in the cell, I want it to show up as 4 in that
cell. Is this possible?
Reply With QuoteReply With Quote