Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why can't I sum two numbers?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |