| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I always display numbers produced from subtractionas posit
How do I display, say "1000 minus 2000" as "1000" Instead of "-1000". However
if the two numbers entered were then changed to say, "2000 minus 1000" it would STILL produce the answer "1000" - again, a positive number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract data frm files produced from templates | Excel Discussion (Misc queries) | |||
| Specific Data Ranges Produced From Drop Down Lists | Excel Worksheet Functions | |||
| display/not display numbers to right of decimal | Excel Discussion (Misc queries) | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
| display the cell that produced a result | Excel Discussion (Misc queries) | |||
Threaded Mode
