convert number to a set multiple of that number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way that I can type in a number into a cell and have a formula multiply that number by .397 and have the result show up in the same cell?
Any help will be greatly appreciated.
 
Only by using VBA, you could get the same effect by putting
0.397 in a cell, copy it, select the cell with the number
and do edit>paste special and select multiply

--

Regards,

Peo Sjoblom


CB said:
Is there any way that I can type in a number into a cell and have a
Click to expand...
formula multiply that number by .397 and have the result show up in the same
cell?
 
CB,
Consider that you'll never see the original number, and if it was keyed
incorrectly, the result will be wrong with no obvious evidence. Better to
key in the value, and use a formula in another column, if at all possible.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

CB said:
Is there any way that I can type in a number into a cell and have a
Click to expand...
formula multiply that number by .397 and have the result show up in the same
cell?
 
Back
Top