Software

Ask something
Discussion Locked

Excel formatting problem

0 helpful
5 replies

by eminent87

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have this Excel worksheet that has a cell that's about 2 paragraphs (1/2 a page) long and for some reason the formatting got screwed up. No matter how much I adjust the cell, it will only display half of the content that's in the cell. Now if I double click on the cell then it'll display the whole thing but this is for editing only, once click out of the cell it'll go back to displaying half of the content.

I have tried increasing the cell, row and column but it's not helping. It is formatted for word wrap. The weird part is no matter how big I make the cell, it will only display half of the content, the remaining doesn't get display. I'm not a pro at Excel so I'm not sure how to go about fixing this, can anybody help?

I've also tried cutting and pasting the same content into a new workbook but got the same problem. I'm using Excel XP. Please help!

5 replies

by eminent87

I tried adjusting everything but it's just not working. I also tried updating my office xp to all the latest updates but I'm still having the same problem.

I was searching microsoft's site but was unable to find the bug you're talking about. If this is a bug then there should be a fix right?

by misscrf

I don't know if this may help, but I wonder a couple of things. Does excel have a field length? I wonder if you hit it. I also wonder if you could change the format of the field to something other than general or text.
Besides for that, I am inclined to ask what you have in that one cell, and if there might be a better way to accomplish what you are doing. It sounds messy, manual and a lot of upkeep in the future. I always say, well never have but am now, do it right now and it will be right forever. lol . Let us know how it is going.

by eminent87

Thanks misscrf. Your answer pointed me to the right direction. I looked up the spec and limitation for excel and found out that each cell is limit to 32,676 characters but only 1,024 characters will be display in a cell. The rest will be display in the formular bar.

I do agree with you that this is not the best way to do it but the user insist on doing it this way.

Thanks again for you help.

This discussion is closed to new replies.