Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise.

Most likely your column just isn't wide enough for the text in the format
you've chosen. Expanding the column widht should do the trick.

"ACICS_Admin" wrote:

Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise.

expand yr column/row

On 19 Gru, 15:54, ACICS_Admin
wrote:
Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. *Please advise. *

I expanded the row and also have the 'wrap text' alignment on. Some cells
with text are just fine, while others are returnning the ######. Can you
think of anything else?

Thanks!

"Jarek Kujawa" wrote:

expand yr column/row

On 19 Gru, 15:54, ACICS_Admin
wrote:
Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise.

Format the cell as General.

String lengths between 256 and 1024 in cells formatted as Text cause this
problem.

ACICS_Admin wrote:

Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise.

--

Dave Peterson