Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
how do i get the decimal point to enter automatic when i enter 123 and i want
1.23 without entering the decimal point manualy? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
Go to the Tools menu, choose Options, then the Edit tab. There,
check the "Fixed decimal" option and enter 2 for the number of places. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jacsells" wrote in message ... how do i get the decimal point to enter automatic when i enter 123 and i want 1.23 without entering the decimal point manualy? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
Toolsoptionsedit and fixed decimal, set it to 2
don't forget to turn it off afterwards -- Regards, Peo Sjoblom "jacsells" wrote in message ... how do i get the decimal point to enter automatic when i enter 123 and i want 1.23 without entering the decimal point manualy? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
Thanks, When I want to go to whole numbers, 123 do I have to go back to
tools, options, edit and remove the fixed decimal check? "jacsells" wrote: how do i get the decimal point to enter automatic when i enter 123 and i want 1.23 without entering the decimal point manualy? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
Thanks, when I want to go back to whole numbers do I need to go back to
tools, options, edit and remove the fixed decimal check? "jacsells" wrote: how do i get the decimal point to enter automatic when i enter 123 and i want 1.23 without entering the decimal point manualy? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
in excel how do i get 1.23 when i enter 123
Yes.
You could leave that Fixed Decimal Places unchecked and use sheet event code to divide your entries by 100 as you enter them. Gord Dibben Excel MVP On Mon, 28 Nov 2005 16:16:04 -0800, "jacsells" wrote: Thanks, When I want to go to whole numbers, 123 do I have to go back to tools, options, edit and remove the fixed decimal check? "jacsells" wrote: how do i get the decimal point to enter automatic when i enter 123 and i want 1.23 without entering the decimal point manualy? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel should let me enter time in one hundreds of a second. | Excel Discussion (Misc queries) | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Tell me what to enter to Export Excel address book to Microsoft O. | Excel Worksheet Functions | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel |