Custom Format to hide the text in a Cell

[Sameer_Kuppanath_Sultan]

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. 

[#2]

@Sameer_Kuppanath_Sultan 

You could use conditional formatting.

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

[#3 · Accepted 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...

=LEN(A1)<=5

Number Format:

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.

[#4]

ok got it-Thanks Sir