Wrap Text in 2007 vs 2003
 

I have a workbook with multiple worksheets where each sheet has merged row
and column cells to create a place for the user to enter text. This cell
merge is formatted as €œtext€� and also to €œword wrap€�. We have been using
this for years in version 2003 with no problem. Now we have a new
workstation with version 2007 on it. This version will not wrap the text in
those cells. Instead we get ##################### etc. all on one line. If
I change the format of the merged cells to €œgeneral€� instead of €œtext€�, it
corrects the problem, but I am not sure if general is going to work for us in
the long run. Is there a simple solution to this? Maybe a new setting or
something? I really dont want to have to go into each of the 60 worksheets
in this workbook and change the formatting.

Wrap Text in 2007 vs 2003
 

but I am not sure if general is going to work for us in the long run.

I'd guess it's the only thing that will work. The only reason to use text
format is if you're entering something that would otherwise go in as a
number, date, formula... Sound like your entries would not have that
problem. Even if they did you could set left-alignment and maybe that would
be okay.

I really don't want to have to go into each of the 60 worksheets in this
workbook and change the formatting.

Not fun. Macro?

Btw, it's a well known problem that text formatted cells (merged or not)
display long text as pounds (see attached), so I don't know why you haven't
seen this before Excel 2007.

--
Jim
"Chris E." wrote in message
...
|I have a workbook with multiple worksheets where each sheet has merged row
| and column cells to create a place for the user to enter text. This cell
| merge is formatted as "text" and also to "word wrap". We have been using
| this for years in version 2003 with no problem. Now we have a new
| workstation with version 2007 on it. This version will not wrap the text
in
| those cells. Instead we get ##################### etc. all on one line.
If
| I change the format of the merged cells to "general" instead of "text", it
| corrects the problem, but I am not sure if general is going to work for us
in
| the long run. Is there a simple solution to this? Maybe a new setting or
| something? I really don't want to have to go into each of the 60
worksheets
| in this workbook and change the formatting.