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

funkcreep

New Member
Joined
Jul 14, 2005
Messages
48
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
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

annadupree

Board Regular
Joined
Mar 23, 2005
Messages
51
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

New Member
Joined
Jul 14, 2005
Messages
48
formated as Text
Wrap Text
I have data, dates, times in there

Excel 2003
 

annadupree

Board Regular
Joined
Mar 23, 2005
Messages
51
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

New Member
Joined
Jul 14, 2005
Messages
48
when I changed the formatting to Scientific or %, the error goes away. Strange.

Thanks for your help

Louis
 

Watch MrExcel Video

Forum statistics

Threads
1,118,071
Messages
5,570,023
Members
412,304
Latest member
citrus
Top