LinkBack URL
About LinkBacks
This solution was provided by Excelchat and I thought others may find it useful. See attached spreadsheet.
This solution was provided by Excelchat and I thought others may find it useful. See attached spreadsheet.
Your Values are returned as text. So you cannot use the sum function on them.
Try this Formula in C2 =MID(A4,7,LEN(A4)-LEN(TEXT(D4,"#,###.00"))-6) and this in D2 =TRIM(RIGHT(SUBSTITUTE(A4," ",REPT(" ",10)),10))*1
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I don't use the number to sum, so it doesn't matter. And, if I did I would just change its format.
It might not matter to you, but I see you are sharing this because it might be useful to others. In most cases where a number is needed, it is needed for a calculation.Originally Posted by getterdun
Yes, I you're right. I didn't think of that. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks