View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default In Excell 2002-Format cells so last 2 digits go to rite of decimal

On Mon, 27 Nov 2006 07:56:02 -0800, Start time in Calendar / Outlook 2002
oft.com wrote:

Just like an adding machine, how can I format the cells so that the last 2
numbers I punch automatically show to the right of the decimal [i.e. 1234
entered shows as 12.34] without having to hit the decimal key?? Thanks for
any help.


If you want it to be like an adding machine, then you don't want to use Format.

Instead, select Tools/Options/Edit
Fixed Decimals
Places: 2


--ron