In Excell 2002-Format cells so last 2 digits go to rite of decimal

  • Thread starter Start time in Calendar / Outlook 2002
  • Start date
S

Start time in Calendar / Outlook 2002

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
Top