| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding negative or positive values (numbers)
Hi , I want to select certain cells and tell them not to display any negative
values , then i want to select other cells and tell them not to display any positive values Office microsoft basic edition Office excel 2003 thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding negative or positive values (numbers)
"not to display" means?
-- Don Guillett SalesAid Software "ryan" wrote in message ... Hi , I want to select certain cells and tell them not to display any negative values , then i want to select other cells and tell them not to display any positive values Office microsoft basic edition Office excel 2003 thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding negative or positive values (numbers)
FormatCellsNumber tab, choose Custom.
In the Type box, enter: For not showing negative numbers: 0;; For not showing positive numbers: ;0-; -- Kind regards, Niek Otten Microsoft MVP - Excel "ryan" wrote in message ... | Hi , I want to select certain cells and tell them not to display any negative | values , then i want to select other cells and tell them not to display any | positive values | | Office microsoft basic edition | Office excel 2003 | | thanks | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding negative or positive values (numbers)
You could also apply conditional formatting to the cells to display, say,
negative numbers, in the same color as the cell's background. This way you retain the cell's value (useful if you need those values to perform calculations elsewhere on your sheet), but make it invisible. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Niek Otten" wrote: FormatCellsNumber tab, choose Custom. In the Type box, enter: For not showing negative numbers: 0;; For not showing positive numbers: ;0-; -- Kind regards, Niek Otten Microsoft MVP - Excel "ryan" wrote in message ... | Hi , I want to select certain cells and tell them not to display any negative | values , then i want to select other cells and tell them not to display any | positive values | | Office microsoft basic edition | Office excel 2003 | | thanks | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding negative or positive values (numbers)
Of course conditional formatting is a good alternative. Both methods retain the cell's value, BTW
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... | You could also apply conditional formatting to the cells to display, say, | negative numbers, in the same color as the cell's background. This way you | retain the cell's value (useful if you need those values to perform | calculations elsewhere on your sheet), but make it invisible. | | Dave | -- | A hint to posters: Specific, detailed questions are more likely to be | answered than questions that provide no detail about your problem. | | | "Niek Otten" wrote: | | FormatCellsNumber tab, choose Custom. | In the Type box, enter: | | For not showing negative numbers: | 0;; | For not showing positive numbers: | ;0-; | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "ryan" wrote in message ... | | Hi , I want to select certain cells and tell them not to display any negative | | values , then i want to select other cells and tell them not to display any | | positive values | | | | Office microsoft basic edition | | Office excel 2003 | | | | thanks | | | | | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding negative or positive values (numbers)
Sorry, I didn't realize applying that custom number format would retain the
cell's value. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Niek Otten" wrote: Of course conditional formatting is a good alternative. Both methods retain the cell's value, BTW -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... | You could also apply conditional formatting to the cells to display, say, | negative numbers, in the same color as the cell's background. This way you | retain the cell's value (useful if you need those values to perform | calculations elsewhere on your sheet), but make it invisible. | | Dave | -- | A hint to posters: Specific, detailed questions are more likely to be | answered than questions that provide no detail about your problem. | | | "Niek Otten" wrote: | | FormatCellsNumber tab, choose Custom. | In the Type box, enter: | | For not showing negative numbers: | 0;; | For not showing positive numbers: | ;0-; | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "ryan" wrote in message ... | | Hi , I want to select certain cells and tell them not to display any negative | | values , then i want to select other cells and tell them not to display any | | positive values | | | | Office microsoft basic edition | | Office excel 2003 | | | | thanks | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
Linear Mode
