Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Sir,
I noticed that for Excel 2002, If I need to add or deduct from 0a number in a cell after F2 function, the user need to add + in front of the number before computation could take effect. For example in cel A2 we have 1200. If I need to deduct 150 from it inside that cell, I usually need to strike F2, follw by + before the numberr 1200 move the cursor forward and enter -150 and strike enter to get the answer. In Corel Quattro Pro Spreadsheet + sign is not required for a cell to add or deduct Thus it is more convenient and time saving. May I know if there a way to set the Excel 2002 worksheet in such a way that, + sign is not necesary ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add zeros in front of numbers | Excel Discussion (Misc queries) | |||
Excel 2002 : How to deduct the first and last number ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Why is my Excel 2002 slow to enter cell? | Excel Worksheet Functions | |||
Auto-Enter Value Based on Table (EXCEL 2002) | Excel Worksheet Functions |