Nov 01 2018 04:33 AM - edited Nov 03 2018 12:55 AM
I have encountered two types of blank in Excel 2013.
The first, when you do =(the blank cell) in another cell, gives 0; the second gives blank.
The first, when you do =(the blank cell)+1 gives 1; the second gives #VALUE!
I have been unable to discover what the difference between the two sorts of blank is, or how to turn one into the other short of Copy and Paste. Both show as General under Format Cells, though =TYPE(the blank cell) gives 1 for the first example (number) and 2 for the second (text).
But both seem quite impervious to having any other TYPE value set for them with Format Cells, or via the use of Format Painter.
What am I looking at here?
Nov 01 2018 03:53 PM
Nov 03 2018 01:01 AM
Thanks Lorenzo. I’ve been a right noob here, and somehow duplicated my thread/conversation, but I will take your advice, and post an example in the other conversation, as that is the one with more replies so far.