I have an application that receives streaming numeric data. Sometimes, the streaming service sends some data that is not numeric or is a 0 (zero), which causes an error in the calculation. How to prevent the cell to be overwritten with text or zero, and leave the previous numerical value unchanged, waiting for a new valid numerical value to arrive? (Excel 365)
Thank you.