Forum Discussion
JyrkiT
Apr 16, 2020Copper Contributor
Excel suppressing zero problem almost solved ...but a serious setback, please help.
Hello, I'm using Excel 2016 in Finnish and encountered a problem with empty cells treated as zeros in my sheet. I'm trying to create a simple way to visualize a set of numbers fed into the sheet as...
JKPieterse
Apr 16, 2020Silver Contributor
There actually is a function that returns #NA!. The function is called NA() in English Excel. So if you start typing PUU into a formula then Excel should show the function's proper name to you.