Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excell 2002-Format cells so last 2 digits go to rite of decimal
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy with format | New Users to Excel | |||
Problem with decimal format | Excel Worksheet Functions | |||
how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |