After you do the replace all, which will remove the periods, you can use the following formula: =LEFT(A1,1)&IF(LEN(A1)=3,RIGHT(A1,LEN(A1)-1)*10,IF(LEN(A1)>3,RIGHT(A1,LEN(A1)-1)))

- In order to replace all, click the column header (A, B, C, etc), press CTRL H - Once that comes up, put a . in the find what field and click the Replace All button.

Once that is complete, periods will be gone and the formula will work.

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?

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.

Please, be forewarned that the site is not secure: - Click the following link: http://www.wikisend.com - Upload the file to that website - Once it is uploaded, the resulting page will display a "File ID" number. - Please, give me that "File ID Number"

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 formula

Assuming the first number is XXXXX A2

=SUBSTITUTE(A2,".","")

Then just copy down the column

feel 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.

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...

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....