I am not able to do calculation on my excel sheet showing #Value! error
I have downloaded the text file from my office website and convert it to excel for doing calculation. I want to remove (-) minus sign from all the values for that I am using =ABS function but it is showing #value! error and secondly I want to do calculation on the data but it is showing same #value! error in output cell. I have tried everything which I know. If somebody can help ? I am attaching sample excel sheet have a look its urgent. Thank You.
say in column C
=ABS(SUBSTITUTE(B1,",","")) fill down
Edit: And welcome to the forum
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
another option would be to use find/replace. find , (comma) replace with nothing
IF you wanted, you could do the same to remove the "-"
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
Thank you mam it solved my problem.
Originally Posted by vlady
say in column C
=ABS(SUBSTITUTE(B1,",","")) fill down
Edit: And welcome to the forum
Thank you very much
This also works
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
-79.952,46
-3,11,477.27
How about these numbers
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks