Find and Replace wildcards

C

Colin Hayes

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
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Popups to supply variables 6
Find & Replace: find part cell, replace whole cell 2
Find and Replace cell 3
Global find and replace in Excel 2007 1
Find *and replace* and wildcards 4
Find and Replace Query with Wildcards in Access 5
find and replace numbers using wildcards 1
How to find and replace text in a document with changing variables 2

Top