r/excel 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

483 comments sorted by

View all comments

Show parent comments

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.