Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative fractions
I am having a problem with negative fractions. I am using MS Excel version
11.0 on Windows 2000 SP4, signed in as administrator. When I try formatting cells as #?/? or ?/? I find that the cell value becomes converted to a positive number. The values that I am using only need to be one significant figure as I am using ±1/3 and ±2/3. Any ideas of some kind of custome format that addresses negative values? I am using both negative and positive values and then adding all of the values in a short column of typically 6 cells. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
irritating warning for negative data on log charts | Charts and Charting in Excel | |||
Negative Values Only | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |