| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks JE. I'm using Office 2000 so I don't have the non VB method.
"JE McGimpsey" wrote: Formatting won't change it, since it's not a number. If you're using XL02/3 use the non-VB method mentioned on the page. If you're using a prior or Mac version, I don't know of a way to do it in-place. In article , "slot guy" wrote: Thanks for the link. Is there a way to change the format while in place without using VB? I'm not experienced with it. Can a custom format be created under "formating cells" to change the negative sign? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
| Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Hybrid Mode
