how can I show text & print instead of #### in Excel even though .

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

Guest

Am using Excel 2000, my last column contains text, some short & some quite
long. The alignment feature has been activated yet #### are shown across the
line both on screen and the printed copy. These #### mean nothing to me for
a printed report, as it is the entered text that is important. As I am not
that computer-literate but can follow directions, is there anyone who may
have encountered this problem able to pass on a solution. It is very very
frustrating, especially since the data being entered does have some long text
which really should conform to the "alignment" feature within Excel. As I am
a senior at home without access to other Excel users, any help is greatly
appreciated. Thank you.
joan
 
You're seeing the ####'s for the cells with pretty long text?

If yes, then try changing that cell's format from Text to General.
(Format|cells|Number tab|General)
 
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

Text won't align at bottom of cells in Excel 2007. 1
How do I remove extra space when text wrapping? 2
Maximum Text in Cells for Printing 1
In Excel, how do I format text to show on screen but not print? 3
Formatting alignment - can I show text upside down? 5
how do you "^go" center text in Excel 2003? 1
show text instead of hash marks 1
Adjusting row height to accomidate text in a cell 2

Back
Top