Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no decimals | Excel Discussion (Misc queries) | |||
decimals only. | Excel Discussion (Misc queries) | |||
question about entering date and time | Excel Discussion (Misc queries) | |||
using decimals points | Setting up and Configuration of Excel | |||
Rounding Decimals | Excel Worksheet Functions |