Text stored in a cell is displayed as a string of "#####..."

  • Thread starter Thread starter Guest
  • Start date Start date
I agree, expand your column width...maybe. But that only displays when the
cell is formated as a number or similar, so make sure that your cell is
formated for Text or General. If the General Setting causeing the same
result, switch to Text.
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009
 
Excel has a problem with string lengths between 255 and 1024 characters.

Format the cells to General instead of Text and the ####### should go away.


Gord Dibben MS Excel MVP
 
Ray

OP stated it was text.

Only numbers need wider column if showing ######

See my other post in same thread.


Gord
 
You must log in or register to reply here.

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

eval of concatenate function not displaying results 1
Sumproduct Date Format Question 6
Text displays as #### 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
How to do double quotes in "cell language"? 4
Custom Number Format for text 8
Number stored as text 4
Text displayed as # in cell 2

Back
Top