Forum Discussion
Solved
Custom Format to hide the text in a Cell
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. ...
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.
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.
ok got it-Thanks Sir