Display contents of "empty" cells

[Bidwin]

Is there a way to display the contents of an "empty" cell in binary or octal or hex to see what's actually there? Average calculations in a spreadsheet showed some errors that must have occurred when I either cleared some cells or entered a space. Using DEC2HEX created a #VALUE error with those cells but showed 00000000 for "new", or untouched, cells.
Thanks.

 

[Toadstool]

Hi Bidwin,

You can use CODE to show the value of the first byte.

Bidwin.xlsx
	D	E	F
1	Cells	Len	CODE
2		1	32
3		1	13
4		1	9
5		1	2
6		1	10
7		1	28
8		1	29
9		1	30
10		1	31
11		1	32
12		2	129
13		2	129 9
Sheet1

Cell Formulas
Range	Formula
E2:E13	E2	=LEN(D2)
F2:F12	F2	=CODE(D2)
F13	F13	=CODE(D13)&" "&CODE(MID(D13,2,1))

 

[Bidwin]

Thanks for your response, Toadstool. I tried "CODE" in some cells but got a #VALUE error. Checking the LEN of those cells returned 0, or, I guess, an empty cell. After checking all suspect cells some were filled with SPACE, LEN 1, so my average calculation must have been treating the space character as a value. Calculation worked OK after CLEARing suspect cells.

 

[Toadstool]

You're welcome. Glad to help.