Displaying hidden characters in a cell

L

Lezlee

Some of our spreadsheets total cells show VALUE. We show
the calculation steps and within the range of the formula
there is a cell (or more than one) that have "bad" data in
them. We isolate which cell and click on it. Nothing
appears in the display area. When we copy a known "good"
or "blank" cell into that cell the error goes away.

We know how to fix the error; we're looking for how to
show what's really there so we can see the "bad" cells
more easily. This becomes more necessary when we have
columns of numbers and blank cells that are 200 rows.

Thank you in advance for any input you can give us.

Lezlee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Characters in cell. 1
How can I display a list of all cells referencing a particular cel 0
Displaying results in formula bar when cell is hidden 1
Excel 2003 - Maximum number of characters a cell can contain? 1
vlookup--2+ items in a cell to display 2+ results in another cell 0
How to display a cell value as a text entry in another cell? 3
Is there a function to show if cell/row(X:Y) is hidden? or width? 3
Displaying & Printing cells with lotsa text 2

Top