Error using the Wrap text and using cell as a text only

[funkcreep]

When I wrap my text in the cell, it works fine for the first 3-4 lines of data. But after that, I get this message ########################## and then i can't read whats in the cell unless I am actuall in the cell and I can read it in the formula bar. What am I doing wrong. I widen the column and make the row higher but that error (############) does not go away.

Thanks

Louis

 

[annadupree]

How is the cell formatted? General, text, number?

Also, what kid of data does it contain? Is there a formula?

I tried to replicate the problem, but couldn't.

 

[funkcreep]

formated as Text
Wrap Text
I have data, dates, times in there

Excel 2003

 

[annadupree]

Sorry, I couldn't replicate the problem. I have 2000.

Try formatting a different cell before pasting that information in. I know that with formulas if the cell is formatted as text you have to re-enter the information after you re-format, so maybe the reverse is also true.

Sorry I couldn't help.

 

[funkcreep]

when I changed the formatting to Scientific or %, the error goes away. Strange.

Thanks for your help

Louis