Try this small macro. It will also tell you the address of the first cell
that has been "pounded":

Sub PoundTest()
Dim r As Range, v1 As String, v2 As String
For Each r In ActiveSheet.UsedRange
v1 = r.Text
If Len(v1) < 0 Then
v2 = Replace(v1, "#", "")
If Len(v2) = 0 Then
MsgBox "pounds found " & r.Address
Exit Sub
End If
End If
Next

End Sub


Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary''s Student - gsnu201001


"Chris_In_Raleigh" wrote:

Is there a way to have excel let me know if any cells are displaying the
##### symbol. I have double clicked on the columns to auto adjust the width
but there are still some cells that will show the ####.

My real reason for this is I don't want a 10+ page table to print and some
cells print ##### as the value. It is hard to check all cells in large
tables visually.

I run into this problem when I use conditional formatting.

Thanks