| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 66374 | 2006-02-20 09:59:00 | Excel cell formatting question | Tony (4941) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 432443 | 2006-02-20 23:26:00 | To fix Mikes problem, try the format string from: _-* #,##0.00_-;-* #,##0.00_-;_-* " "??_-;_-@_- to _-* #,##0.00_-;- #,##0.00_-;_-* " "??_-;_-@_- Seems to work (removal of the "*" affects the alignment of the minus), not sure if you need them all removed but the second one in seems to be the one you need Mike. |
godfather (25) | ||
| 432444 | 2006-02-20 23:49:00 | :waughh: Unless I'm missing something here, why not just select Tools Options and on the View tab, deselect the zero values checkbox. :cool: | Miami Steve (2128) | ||
| 432445 | 2006-02-21 00:48:00 | :waughh: Unless I'm missing something here, why not just select Tools Options and on the View tab, deselect the zero values checkbox. :cool:That seems to work - didn't even know that option existed. I guess the difference is that that is a universal option, which may not be what you actually want, whereas what has been discussed is at the individual cell level. | Tony (4941) | ||
| 1 2 | |||||