Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
hi, have been trying to get a Custom format to work for excluding certain
text characters would think that where [=9]"";0 works for numbers; can not get to work for text, e.g.: [="xx"]"";General does not work, any suggestions or can MS fix ? thanks have bee trying to get a formula to be able to sort, with "xx" as the negative result, am trying to get "xx" removed from view. e.g. formula: =IF(quantity <50,"xx", else true where variations of output (as text) include: a0 br dd p0 p1 p2 p3 v1 v2 xx There does not seem to be a ready made Custom Format for hiding text... not working: ["xx"]"";General [="xx"]"";General General;General;General;[Yellow]General [Yellow]"xx";[Black]General [Yellow]Text="xx";[Black]General 0;-0;;@ ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Formatting
Not a custom format as such, but perhaps this type of formula might help.
=IF(ISTEXT(IF(A1<50,"xx",A1)),"",A1) or maybe just =IF(A1<50,"",A1) Vaya con Dios, Chuck, CABGx3 "Nastech" wrote: hi, have been trying to get a Custom format to work for excluding certain text characters would think that where [=9]"";0 works for numbers; can not get to work for text, e.g.: [="xx"]"";General does not work, any suggestions or can MS fix ? thanks have bee trying to get a formula to be able to sort, with "xx" as the negative result, am trying to get "xx" removed from view. e.g. formula: =IF(quantity <50,"xx", else true where variations of output (as text) include: a0 br dd p0 p1 p2 p3 v1 v2 xx There does not seem to be a ready made Custom Format for hiding text... not working: ["xx"]"";General [="xx"]"";General General;General;General;[Yellow]General [Yellow]"xx";[Black]General [Yellow]Text="xx";[Black]General 0;-0;;@ ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Custom Formatting | Excel Discussion (Misc queries) | |||
custom formatting | Excel Discussion (Misc queries) | |||
Custom Formatting | Excel Discussion (Misc queries) |