however, what if some of the values contain a letter preceding the number:
want to make V130
I NEED TO MAKE INTO
THE NUMBER HAS TO HAVE MINIMUM 3 NUMBERS MAX 5
PLEASE EXPEDITE ANSWER FOR GOOD RATING AND POTENTIALLY A BONUS
the problem is i cannot do the replace all in the values where there are letters. what is 'replace all?' did we discuss this?
also the example you sent has two identical columns....
this is excellent and worked almost perfectly. the only problem, and it was probably because i did not tell you all the information, is that i get errors when the values are only 1 or 2 numbers.
could you explain the concept of this code?
finally, would it be possible to add one zero to all numbers that are only two digits and add 2 zeros to all numbers that are one digit. remember how i said the minimum should be three numbers?
this is not working for me, i think there is something wrong
it is doing it for the row above it.
i am having a hell of a time copying the formula from your file to my file. when i copy the formula you provided here, i am getting errors in cells with only one digit.
My Name isXXXXX will be helping you today. If I provide good service, you may ask for The-PC-Guy in your question title for your future needs.this is much simpler that the previous expert made it. Just use the following formulaAssuming the first number is XXXXX A2=SUBSTITUTE(A2,".","")Then just copy down the columnfeel free to ask for me again in the future if I can be of any more assistance,
http://www.justanswer.com/computer/expert-1expert-2rulethemall/If you want the right answer the first time, please contact me directly for all of your future computer questions, to get the fastest and most accurate service possible.PLEASE DON'T FORGET TO RATE ME GOOD OR EXCELENT SERVICE, 4 OR 5 STARS OR SO I WILL BE PAID FOR MY TIME.
it is not just about decimal points. you need to read the whole thread. it is more complicated than removing a decimal point.
i see you said this, what doesn't make sense is why you want to turn V3.2 into V320 and why now E4.56 into E4560?
What is the criteria for adding a zero. Is it that all values need to have a minimum of a Letter and 3 numbers, and if it has less you want to add the zero to keep it the same?
Please give me your criteria, and I can make the modifications. This is all easily doable.
there needs to be a minimum of 3 numbers. Thus if a number is XXXXX digit, two zeroes needs to be added. If a number is XXXXX digits, one zero needs to be added. Otherwise, if number is XXXXX 4, or 5 digits, nothing needs to be added just a removal of decimal point...
won't work.....nothing happens, it does not even run. i have excel windows 7.
the workbook is in the thread..........wikisend......here it is again:
sorry, missed it.I downloaded from the link you sent, and don't see any decimal points. yes I removed them
So you want everything in column B to = Column A with 3 - 5 digits?
yes including the ones with letters infron of them at the bottom of column A.
I certainly won't forget to rate.
however, could you tell me what the file is called? When I open I see a bunch of .xlm files. when it opens it doesn't even make sense....
if you are a/v asap, i made a mistake and asked you to add two ending zeros. I meant add leading zeroes. that is two zeroes for a one digit, and one zero for a two digit. I have to have results this morning....