Thanks, that did help. Now how do I keep the text flowing from the TOP of
the cell rather than the Bottom?
--
Lizette Koehler


"Gord Dibben" wrote:

Excel has a problem with text-formatted cells if they contain between 255 and
1024 characters.

Changing the format to General seems to be the only way to get rid of the
##########'s


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 10:28:01 -0700, Lizette Koehler
wrote:



First, please I know this is bad, but my manager has made this requirement.

I am trying to take my Word Doc and place it into an Excel Spread sheet.
This document has bullets and numbering.

What I am running into is cells with ######### all the way across. I have
tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and
Column - No luck. I have tried to maximize the cell - no luck.

The section of the document I am working with looks like this:



€¢ An incident was declared with the Desktop due to abnormal storage errors
that caused the system to get recursive OC4 abends. The mean time to
resolution was 4hr 12min, resulting in the scheduled maintenance window being
exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the
following quality improvement was implemented in response to this incident.

1. Tech Support Technicians created a new OPS/MVS non scrollable console
message to alert Operations immediately if this error occurs again. This
will improve mean time to resolution should this reoccur.


But when I place it into a cell (either manually typing it in or paste
special using TEXT) it goes to ##### in the cell.

Is what I am trying to do possible or are there limits to putting text into
a cell? If so, what are the rules (or where do I find them)

This is a management thing not mine. I would have left it in word.