View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris E. Chris E. is offline
external usenet poster
 
Posts: 1
Default 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.