| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell to show '-'
they do not have to display as negative, but I want them to function as
negative. If any number is entered, it will be seen as a negative number by formula referencing that cell. Thanks, Gary "Rick Rothstein" wrote: Can there be actual negative values in your cells and, if so, how should they display? -- Rick (MVP - Excel) "Gary" wrote in message ... Looking for a way to make entries into cell show negative (-) indicator by default. For instance if '1' is entered, it will display '-1'. Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell value to show kg? | Excel Discussion (Misc queries) | |||
| format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
| Format cell to show colon | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Threaded Mode
