| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you format a cell to automatically multiply entry times 2?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you format a cell to automatically multiply entry times2?
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? If you want to put 4 in a cell instead of 2, why don't you just type 4, he asked facetiously. <g Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell when I type 10 it will multiply 10 by .585 | Excel Worksheet Functions | |||
| to Don: display last entry to cell automatically | Excel Worksheet Functions | |||
| display last entry into a cell automatically | Excel Worksheet Functions | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| how can I multiply a 45-vector times a 45*45 matrix? | Excel Discussion (Misc queries) | |||
Hybrid Mode
