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!