Thread: Enter multiple numbers in a cell so total shows when enter keypres
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default Enter multiple numbers in a cell so total shows when enter keypres
Sun, 19 Aug 2007 02:14:00 -0700 from newbie
:
I wish to enter a series of numbers (both + and -) in an excel spreadsheet
cell and after pressing enter only the final total shows

Nothing easier, just put the = sign before the first number.

--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote