If a cell is formatted as text and contains over 255 characters but less than
1025, you can see this ####.

You can also see it if you have a negative number and the cell is formatted as
time/date (not using 1904 date system).

As well as some number formats where the column width is too narrow.

CyberTaz wrote:

Hi Sarah-

The symbols you see only appear if there is a formatted value in the cell
and the column is not wide enough to display the entire amount. (Cells that
contain text do not display these symbols regardless of how much text they
contain.)

The three most common ways to correct the situation a

1- Use different formatting if possible,

2- Use smaller font size if possible, or

3- Increase the column width as necessary.

Opton 3 merely involves clicking the column heading at the top of the column
(A, B, C, D, E, etc.), then go to FormatColumnAutoFit Selection. If this
makes the column too wide based on other content in the column, select just
the range of cells displaying the symbols and repeat the process (or you
could do it this way first).

For more options, see Excel Help on Column Width.

HTH |:)

"Sarah" wrote:

I am entering text into a cell & can see it in the formula bar up top, but
it's giving me the #### in the cell that states it's too big. How can I get
it to show my text?

--

Dave Peterson