Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replace with wildcards | Excel Discussion (Misc queries) | |||
find and replace \n wildcards like word | Excel Discussion (Misc queries) | |||
Find and Replace with wildcards? | Excel Discussion (Misc queries) | |||
Why not accept wildcards for REPLACE as well as FIND ? | Excel Discussion (Misc queries) | |||
Replace using Wildcards | Excel Worksheet Functions |