LinkBack URL
About LinkBacks
What is the function to add numbers in a single cell to show only a single number. I know it can be done but do not know the quick function to do it.
Mel
adding numbers in a single cell
What is the function to add numbers in a single cell to show only a single number. I know it can be done but do not know the quick function to do it.
Mel
Last edited by NBVC; 03-31-2009 at 04:09 PM.
Please give an example of what you mean
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
If you're talking about typing in a formula in a single cell but having it contain only the final number;
type in the formulaand before hitting enter, hit F9. The final value 16 will be in the cell sans formula. Is that what you want?
=7+9
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Here is an example of what I mean.
=3+2+8-3+7-10 it shows this in the cell. But there is a function that when it is all added up only will show a single number 7. It actula sums it up and replaces all the number to a single number. It is like a F5 or Cnt Alt function.
I hope this if helpful.
See ChemistB's response above
I tried f9 but the they are already total is there another way.
Hit F2 to re-activate the cell, then hit F9. Then hit EnterOriginally Posted by mmurrhee
Thank you...that worked. I knew it could be done.
Mel
Wow, I can't believe I guessed what he wanted!
good job... I didn't even guess that was where the question was going...saved a lot of back and forthing, I'm sure.Wow, I can't believe I guessed what he wanted!
If you are satisfied with the solution provided, please mark your thread as Solved.Thank you...that worked. I knew it could be done.
Mel
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks