I'm using Excel to convert from Hex to Decimal and vice versa. I put, for example, the decimal in A3 and I want the hexadecimal number to appear in B3. I've got that all down fine, but if there is no number in A3 I would like B3 to be blank instead of displaying a 0. Can you help me? Thanks!
2007-05-01 12:58:20 · 4 answers · asked by Brndn 3 in Computers & Internet ➔ Software
You can use the "if" function. i.e
= if (a3="",b3="",xxxxxxxx)
"" 2 inverted comas mean "blank" in these functions
I have put xxxxxxx instead of your formula. type the formula in that space
2007-05-01 13:38:07 · answer #1 · answered by voyager 6 · 1⤊ 0⤋
Display or hide zero values on an entire worksheet
1 On the Tools menu, click Options, and then click the View tab.
2 To display zero (0) values in cells, select the Zero values check box.
To display zero values as blank cells, clear the check box.
2007-05-01 13:04:47 · answer #2 · answered by TheHumbleOne 7 · 1⤊ 0⤋
Change column B from a numeric value format to text format.
Right click on the B column header > format cells > number tab - pick text from the Category listing
2007-05-01 13:02:15 · answer #3 · answered by spl 4 · 0⤊ 0⤋
make an if statement =IF(A3=0,"",DEC2HEX(A3))
2007-05-02 17:47:33 · answer #4 · answered by Anonymous · 0⤊ 0⤋