ExcelBanter - QUESTION ABOUT ENTERING DECIMALS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - QUESTION ABOUT ENTERING DECIMALS (https://www.excelbanter.com/excel-discussion-misc-queries/166184-question-about-entering-decimals.html)

Susan

QUESTION ABOUT ENTERING DECIMALS

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

Thank you!

Bernard Liengme

QUESTION ABOUT ENTERING DECIMALS

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SUSAN" wrote in message
...
Is there a way that when i enter the number 65.26, the cell will change
the
number to .6526?

Thank you!

Rick Rothstein \(MVP - VB\)

QUESTION ABOUT ENTERING DECIMALS

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

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

All times are GMT +1. The time now is 03:45 AM.