QUESTION ABOUT ENTERING DECIMALS

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

Guest

Is there a way that when i enter the number 65.26, the cell will change the
number to .6526?

Thank you!
 
Not as you enter it, unless you use VBA
However, it is easy to change a range of values after they have been
entered.
Suppose the range is A1:B10
In some empty cell (C1) type 100; Copy C1
Select A1:B10; use Edit | Paste Special and specify Divide
When done, you may delete C1
best wishes
 
Is there a way that when i enter the number 65.26, the cell will
change the number to .6526?
Click to expand...

Is the 65.26 a percentage? If so, you can format your cell(s) as
Percentage... then when you enter 65.26, it will display as 65.26%, but the
actual underlying value will be 0.6526 and that is the value that will be
used in calculations involving the cell(s).

Rick
 
Back
Top