| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace using wildcard, or else
(1) When I download my transaction record from a bank, excel seems to treat
the value, for example, $ 12.34 as text and I cannot do arithmetic. I tried Format|Cell command but it does not work because of stupid $. (2) So next I tried to replace $ 12.34 by 12.34 using woldcard but when I try replacing $ * by *, $ 12.34 becomes * instead of 12.34 !!! Any easy way to solve my problem? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find & replace - digit wildcard | Excel Discussion (Misc queries) | |||
| Find and Replace Command Using Wildcard Help | Excel Discussion (Misc queries) | |||
| Find Replace Wildcard | New Users to Excel | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
