View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
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