| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Replace to Format Negative Numbers
We receive data from an outside source and have no control over its
appearance. On their worksheet negative numbers show up like this $4.33- or 8-. I can use a wildcard character in the search field to find these occurences but have found that I can't change the format to the proper one, - $4.33 or -8. In the search field I enter *- but if I enter -* in the replace field, Excel replaces my number with -*. Suggestions? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
| Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
| How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Threaded Mode
