Prev: addendum 2
Next: Not sure what type of formula to use
From: Colin Hayes on 16 Feb 2010 16:30

Hi All

I need a little help.

What would be the codes to enter in the Find and Replace boxes so that
the second decimal place in any number would be replaced with a given
number?

For example

5.97
16.23
22.64
9.66
105.26

Would become

5.95
16.25
22.65
9.65
105.55

if I wanted to search and replace the second digit to a 5.

Grateful for any advice.



Best Wishes
From: Per Jessen on 16 Feb 2010 16:48
Hi

You can not use Find/Replace for this. Use a helper column to calculate the
the desired values, copy values in the helper column, and use paste special
to replace the original values:

=(INT(A1*10)+0.5)/10

Regards,
Per


"Colin Hayes" <Colin(a)chayes.demon.co.uk> skrev i meddelelsen
news:djK8pLA45weLFwHP(a)chayes.demon.co.uk...
>
> Hi All
>
> I need a little help.
>
> What would be the codes to enter in the Find and Replace boxes so that the
> second decimal place in any number would be replaced with a given number?
>
> For example
>
> 5.97
> 16.23
> 22.64
> 9.66
> 105.26
>
> Would become
>
> 5.95
> 16.25
> 22.65
> 9.65
> 105.55
>
> if I wanted to search and replace the second digit to a 5.
>
> Grateful for any advice.
>
>
>
> Best Wishes

From: Teethless mama on 16 Feb 2010 18:16
=FLOOR(A1,0.1)+0.05


"Colin Hayes" wrote:

>
> Hi All
>
> I need a little help.
>
> What would be the codes to enter in the Find and Replace boxes so that
> the second decimal place in any number would be replaced with a given
> number?
>
> For example
>
> 5.97
> 16.23
> 22.64
> 9.66
> 105.26
>
> Would become
>
> 5.95
> 16.25
> 22.65
> 9.65
> 105.55
>
> if I wanted to search and replace the second digit to a 5.
>
> Grateful for any advice.
>
>
>
> Best Wishes
> .
>
 | 
Pages: 1
Prev: addendum 2
Next: Not sure what type of formula to use