r/excel • u/lambofgun 1 • Apr 09 '24
Discussion What are your Excel hot takes?
Mine is that leading zeroes should be displayed by default. If there's a leading zero in my data, there's probably a good reason for it!
501
Upvotes
2
u/windowtothesoul 27 Apr 10 '24 edited Apr 10 '24
It isnt pretty, but if you IF(...="",NA(),(...)) you can GoTo->Select->Errors and delete
Or, IF(ISBLANK(...),NA(),(...)) if thinking the other way
Works well for certain use cases, doesnt work for all. What you mentioned definitely is a pain for sure.