Assuming your list is in column A, put the following formula in B1 and copy
down..........

=(INT(A1)&MID(A1,FIND(".",A1,1),2)&5)*1

Vaya con Dios,
Chuck, CABGx3


"JR" <gaspower@aol.com> wrote in message
news:SgNpe.1436$bv7.732@newssvr21.news.prodigy.com...
> Hello,
>
> I have a column of numbers that end in many different numbers such as
7.66,
> 3.43 ect. I would like to make all the numbers to end in 5. Such as 7.65
and
> 3.45.
>
> Thanks JR,
>
>