View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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