Cell Formatting Advice:- Text displayed as .........#######

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I merge say Cells A6 to G6....and format the area for text alignment top
left and autowrap selected.......
I find that although the text I chose to enter (can be several sentences),
appears fine when in the merged cell area.....when I click ou of the
area.....I get a string of "#############".....clicking back into the cell
area reveils the text again...... I have tried adjusting cell column
widths but this doesn't help.....I have searched online help.....no
joy.....any suggestions would be appreciated.
 
I would strongly recommend not using merged cells, it is hardly ever
necessary but it will almost always cause headeaches in one way or another,
however if you format the cell as general instead of text you might avoid the
####


Regards,

Peo Sjoblom
 

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

Overlap Cells Vertically without Merging 2
wrapping of very long text in EXCEL 2002 cells 3
wrapped text in cells not displaying 2
Text Alighnment Across Selection 3
Behavior of text in cells..... 1
Wrap text is tempermental within a single cell 2
Conditional formatting in Excel 2010 2
merge cells without losing data OR format 1

Back
Top