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
|