excel formula - renumbering ids - 6 number change

i have the following codes in excel
025.555_0010 (in cell A60) and i want a formula to change the 1st 6 numbers of the id so that it reads for example 010.560_0010 could you please assist with a formula for cell A60

OS im using is windows 7
markbancks

="010.560"&MID(A60,7,100)

SOLUTION
Rob Henson

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you tryed using Find and Replace (Ctrl+H) Excel's function for this?
Capturar.JPG

these solutions dont work for hundreds of items i need to change, they only work for a single item, i need to copy and paste the formula, please adjust

the problem i have is that i need a formula to adjust not only the 1st 3 numbers, ie 025, which is ok if i use the formula below, but i also need to adjust the next 3 numbers of the id ie 555,in the same formula. so the id should read after the formula is applied 010.900_0020

025.555_0020
=SUBSTITUTE(A61,"025","010")
duderde

If you want to replace the numbers directly in column A you will have to use a macro.
How do you get the replacement numbers? Are they different for every line in the column or is it always 010.900? Where do you define that?
Please provide a longer excerpt from your worksheet, so that the problem becomes clearer.