How do you format a cell to automatically multiply entry times 2?

H

HL Charts

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?
 
S

Shane Devenshire

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.
 
B

Bill Sharpe

HL said:
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?
Click to expand...

If you want to put 4 in a cell instead of 2, why don't you just type 4,
he asked facetiously. <g>

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
Format a Range to Multiply by 1000 5
Excel does not accept text format! 0
Formatting question: how to format duration (time spent)? 0
Need Help with a VBA subroutine 0
Conditional Formatting 3
How do I multiply the content of a cell by a number 2
Automatic indexing in footnotes - solved 0

Top