| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
negative $'s will not show as red, even though I selected it. I ha
-- ask question2 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
negative $'s will not show as red, even though I selected it. I ha
If the cells were formatted as TEXT prior to your formatting them for numbers
you red negative format will not show. Additionally, if the number was entered as text, indicated by an apostrophe preceeding the entry your assigned number format does not show. -- Kevin Backmann "ask questions" wrote: -- ask question2 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
negative $'s will not show as red, even though I selected it. I ha
Are the numbers "real" numbers or text that look like numbers?
Can you add and multiply with the numbers? What do you get when you enter =ISNUMBER(cellref) in an adjacent cell? If FALSE, format all to General then copy an empty cell. Select the range of numbers and EditPaste SpecialAddOKEsc Gord Dibben MS Excel MVP On Tue, 24 Jun 2008 11:42:04 -0700, ask questions wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display in a selected cell the 1st negative value's matching date | Excel Worksheet Functions | |||
| if the # is a negative #, then show 0 | Excel Discussion (Misc queries) | |||
| if the # is a negative #, then show 0 | Excel Discussion (Misc queries) | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| How can i put a negative sign on a range of selected cells? | Excel Discussion (Misc queries) | |||
Linear Mode
