| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format text
hi, is there a way to make a specific text, in a column to "not" appear?
have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Format text
To "hide" 0s:
0;-0;;@ But I'm guessing you want to do it for some other value! -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, is there a way to make a specific text, in a column to "not" appear? have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Format text
yes, for text, e.g.: xx
have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. (do not see a ready made custom format for text). "T. Valko" wrote: To "hide" 0s: 0;-0;;@ But I'm guessing you want to do it for some other value! -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, is there a way to make a specific text, in a column to "not" appear? have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Format text
have a column want to sort "off-lines" to end, instead of NOT situation
="", have to use characters.. Sorry, I have no idea what that means. How about using conditional formatting to set the font color to be the same as the fill color? -- Biff Microsoft Excel MVP "Nastech" wrote in message ... yes, for text, e.g.: xx have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. (do not see a ready made custom format for text). "T. Valko" wrote: To "hide" 0s: 0;-0;;@ But I'm guessing you want to do it for some other value! -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, is there a way to make a specific text, in a column to "not" appear? have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Format text
hi, that would otherwise work, but am using all 3 cond. formats
really just need to hide a double x: xx use not so important, but have lines that are below value, they are formula'ed to turn off in such a case, e.g.: if levels less than 50, display nothing: =IF(quantity<50,"",else true sorts unwanted records to top, need them to bottom, replace "" with: "xx"; do not want to see the "xx". "T. Valko" wrote: have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. Sorry, I have no idea what that means. How about using conditional formatting to set the font color to be the same as the fill color? -- Biff Microsoft Excel MVP "Nastech" wrote in message ... yes, for text, e.g.: xx have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. (do not see a ready made custom format for text). "T. Valko" wrote: To "hide" 0s: 0;-0;;@ But I'm guessing you want to do it for some other value! -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, is there a way to make a specific text, in a column to "not" appear? have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Format text
Maybe this:
General;General;General;[White]General *ALL TEXT* entries will appear in a white font. Change White to be the same as the fill color. However, conditional formatting will take precedence. -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, that would otherwise work, but am using all 3 cond. formats really just need to hide a double x: xx use not so important, but have lines that are below value, they are formula'ed to turn off in such a case, e.g.: if levels less than 50, display nothing: =IF(quantity<50,"",else true sorts unwanted records to top, need them to bottom, replace "" with: "xx"; do not want to see the "xx". "T. Valko" wrote: have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. Sorry, I have no idea what that means. How about using conditional formatting to set the font color to be the same as the fill color? -- Biff Microsoft Excel MVP "Nastech" wrote in message ... yes, for text, e.g.: xx have a column want to sort "off-lines" to end, instead of NOT situation ="", have to use characters.. (do not see a ready made custom format for text). "T. Valko" wrote: To "hide" 0s: 0;-0;;@ But I'm guessing you want to do it for some other value! -- Biff Microsoft Excel MVP "Nastech" wrote in message ... hi, is there a way to make a specific text, in a column to "not" appear? have tried variations on use of 0 example: [=0]"";0 can not get to work for text, thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
| Create custom text format? | Excel Discussion (Misc queries) | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
| Custom format with text | Excel Discussion (Misc queries) | |||
Hybrid Mode
