Forum Discussion
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.
3 Replies
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
