| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with Find & Replace
Hi All, My spreadsheet contains bank account numbers that contain "-" and spaces. To get rid of these characters I use Edit Find Replace. When I do this the last digit of the 16 digit number changes to a zero rather than show the correct number. The first 15 digits of the account number are fine. Its just the last digit that seems to be affected. Any ideas? Regards Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=530795 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find and replace the " | Excel Discussion (Misc queries) | |||
| Find and Replace | Excel Worksheet Functions | |||
| find and replace in workbooks | New Users to Excel | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
Threaded Mode
