Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Libby
 
Posts: n/a
Default Why can't I sum two numbers?


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Umm ...
1) calculation is set to manual rather than automatic (tools / options /
calculations)
2) they're not really numbers but numbers entered as text (right mouse click
on them, choose format cells and see what is selected) - to change, copy a
blank cell (from another sheet) click on your "numbers" choose edit / paste
special - add. Type your formula again and see it works.
3) you don't know the formula try =A1+B1 where A1 & B1 are your cell
references

if none of these are what you're after, feel free to post back with a few
more details.

Cheers
JulieD

"Libby" wrote in message
...



  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you can't post a proper question explaining what you want in the BODY of
the message, why would you be able to sum two numbers?


Regards,

Peo Sjoblom
  #4   Report Post  
Ken Wright
 
Posts: n/a
Default

Why won't my car start is a similar question, so try calling the garage and
just asking that. You really need to take the time to state the question in
such a way that you give us as much relevant information as possible. You
may have all the details in front of you but we have to rely solely on what
you communicate to us by way of your post.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Libby" wrote in message
...



Reply
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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Averaging Numbers when 2 numbers in one cell Ourania Excel Worksheet Functions 8 January 12th 05 06:40 PM
Sorting when some numbers have a text suffix confused on the tundra Excel Discussion (Misc queries) 5 December 18th 04 10:19 PM
Sorting imported "numbers" Confused on the tundra Excel Discussion (Misc queries) 5 December 17th 04 07:33 PM
finding common numbers in large lists Jenn Excel Worksheet Functions 1 November 11th 04 07:42 PM


All times are GMT +1. The time now is 04:29 AM.

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

About Us

"It's about Microsoft Excel"