Excel 2007 bug? Merged cells must be formatted as scientific

C

CherylLynn

Trying to find out if this is happening with anyone else. To display the
text entered into merged/wrapped cells in Excel 2007, I have to format it as
"scientific" instead of as text. Bizarre! I use merged/wrapped cells
extensively and never came across any issues prior to the upgrade to Office
2007. If I don't format the text as scientific, it is displayed (and prints)
as a long string of ##### signs.
 
G

Gord Dibben

Have you tried formatting as General.

This stops the display of ############# in earlier versions of Excel.


Gord Dibben MS Excel MVP
 
R

Ron Rosenfeld

Trying to find out if this is happening with anyone else. To display the
text entered into merged/wrapped cells in Excel 2007, I have to format it as
"scientific" instead of as text. Bizarre! I use merged/wrapped cells
extensively and never came across any issues prior to the upgrade to Office
2007. If I don't format the text as scientific, it is displayed (and prints)
as a long string of ##### signs.

I do not replicate your problem in Excel 2007 with the information you provide.

I would suggest providing more detailed information, as there may be some other
issue going on than what you conclude.
--ron
 

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

Top