SOLVED

Custom Format to hide the text in a Cell

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3141432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECustom%20Format%20to%20hide%20the%20text%20in%20a%20Cell%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3141432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EHi%20All%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20hide%20the%20number%20by%20using%20Custom%20Format%20based%20on%20Length%20of%20the%20text%20.%26nbsp%3B%20(Highlighted%20Column-%20Len(a1)%26lt%3B%3D5).%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20use%20any%20format%20or%20VBA%20for%20this.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346523iEE7448B88D87D8F5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Sameer_Kuppanath_Sultan_0-1644391632437.png%22%20alt%3D%22%5C%26quot%3BSameer_Kuppanath_Sultan_0-1644391632437.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3141432%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Frequent Contributor

 

Hi All

I would like to hide the number by using Custom Format based on Length of the text .  (Highlighted Column- Len(a1)<=5). 

I don't want to use any format or VBA for this. 

Sameer_Kuppanath_Sultan_0-1644391632437.png

 

 

 

 

3 Replies

@Sameer_Kuppanath_Sultan 

 

You could use conditional formatting.

Formula =Len($a1)<=5
Number Format ;;;

JMB17_1-1644392284750.png

 

 

 

best response confirmed by Sameer_Kuppanath_Sultan (Frequent Contributor)
Solution

Hi @Sameer_Kuppanath_Sultan 

 

it will not work with a custom number format. But you could use conditionally formatting. Menue path:

Home | Conditional Formatting | New Rule...

DTE_0-1644392284141.png

=LEN(A1)<=5

Number Format:

DTE_1-1644392320059.png

The ;;; is on a German environment. It could be that you need to use ,,, instead, depending on your local settings. Just give it a try.

 

 

ok got it-Thanks Sir