LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default Excel 2002: Need to enter+ in front of the numbers to deduct

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add zeros in front of numbers dlb1228 Excel Discussion (Misc queries) 3 March 29th 07 05:48 PM
Excel 2002 : How to deduct the first and last number ? Mr. Low Excel Discussion (Misc queries) 4 January 8th 07 03:47 PM
Excel 2002 : Convert Positive Numbers to Negative Numbers ? Mr. Low Excel Discussion (Misc queries) 2 November 6th 06 03:30 PM
Why is my Excel 2002 slow to enter cell? hkrdskh Excel Worksheet Functions 1 July 1st 06 06:25 PM
Auto-Enter Value Based on Table (EXCEL 2002) Christopher in Bellefontaine Excel Worksheet Functions 2 April 24th 05 03:33 AM


All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"