Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Add Mode" in Excel
Hi all,
On many adding machines there is an add mode where you can enter numbers without hitting the decimal point and the decimal point is automatically added at two places. Is there an equivalent setting in Excel for data entry? Thanks Andrew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Add Mode" in Excel
Tools/ Options/ Edit/ Fixed decimal places
(but remember to turn it off again when you want normal entry). -- David Biddulph "Andrew" wrote in message ... Hi all, On many adding machines there is an "add mode" where you can enter numbers without hitting the decimal point and the decimal point is automatically added at two places. Is there an equivalent setting in Excel for data entry? Thanks Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I turn on/off "Design mode" in Excel 2007 | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions |