Display Blank when Referencing Blank Cell in Excel 2010

[ForumBot]

Display Blank when Referencing Blank Cell in Excel 2010

[ForumBot]

You need to force Excel to treat the contents of the cell as a text value instead of a number, which it does automatically with blank values.

```
=A2 & ""

```

This will force Excel into making that cell reference a text value,
thus preventing the conversion of blanks into zeroes.