Hello, got a question for you:
When i put this is a cell: 20+1
That cell is calculate for me and read: 21
But what if i want that cell to show exacly like this: 20+1
Hello, got a question for you:
When i put this is a cell: 20+1
That cell is calculate for me and read: 21
But what if i want that cell to show exacly like this: 20+1
Last edited by Koford; 03-19-2018 at 01:07 PM.
Use;
Formula:Please Login or Register to view this content.
did not work for me
What does it give you?
Uhm for some reason something wrong is going on here.
I could swear earlier i could write 20+1 and it calced out for me as 21. Now, it doesnt calc 20+1 just show as it is without calcing.
When i try ;20+1 or '20+1 both just show as it is without calcing.. hmm weird.
maybe format cell as TEXT then input your 20+1
I tried General, Number, Text and everytime I got : 20+1 not 21
I have no problem entering (exactly like this) 20+1 into a cell, and have it show that way - the cell is formatted as General
H I J 5 620+1 7
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you want the cell to show 21, you must enter it like this:
=20+1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ali, I think the OP wants to show 2+1 (I could have read it wrong though lol)
But what if i want that cell to show exacly like this: 20+1
I was looking at this (and the thread title):
I'm not sure which he wants!!!I could swear earlier i could write 20+1 and it calced out for me as 21. Now, it doesnt calc 20+1 just show as it is without calcing.
Last edited by AliGW; 03-19-2018 at 02:15 AM.
I agree, seems that it started as showing 20+1, then changed to =20+1
or all in one:
a b c 120+1 21=--left(a1,search("+",a1)-1)+mid(a1,search("+",a1)+1,99)
Im sorry, i may have provided bad information.
I can write 20+1, but it doesnt calc it... further on the last line i have a cell with: =sum that will calc all number's iv provided.
Yes i know that: =20+1 works.... but then doing this will show 21 in the cell.
All i want, that this cell show 20+1 and in the =sum cell it will calc it as 21.
You may wonder why i want to put 20+1 instead of 21?
Is because i want to show everyone else that this guy got 20 point in addition 1 point extra for his fastest time.
Putting numbers 21 may confuse other, putting 20+1 everyone else understand what this means.
We have a system that we giving member's point 20, 18, 16 and then 15,14,13,12 and so on.
Also 1 point for fastest time.
So if this guy didnt win or came 3. place (That will give him 16 point).
This guy also was the fastest and will be given 1 point for that..so as this: 16+1.
This information everyone understand instead of putting number: 17.
I hope this provide enough information
Last edited by Koford; 03-19-2018 at 09:30 AM.
One way:
=IF(A1="","",SUMPRODUCT(--MID(SUBSTITUTE(0&A1&"+0","+",REPT(" ",100)),{1,101},100)))
If this isn't correct...
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Why don't you make your life easier by having one column for the score and another to the right for extra points earned? It would make the summing so much easier.
Last edited by AliGW; 03-19-2018 at 01:35 PM.
Yea you correct, i could do that, and this is what im working on now.
One more question:
In a cell(D5) i have:
If you look at D$20 to D$31 i have not put anything in those cell's except one person gets number 1, .... but as a result of this, all other cell's show number: 0 (D5 gets this zero...and so on)Please Login or Register to view this content.
This looks messy with all those zero's, is there a way to hide all those?? the formatting will look better.
Nevermind, i think i got it. I was googled a little around.
All i did was format the cell --> Numbers --> User Define and wrote this: 0;;;@
Edit: I would like to thank you all for trying to help me. All sorted now. !!
You’re welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks