Thread: Truncated data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Truncated data

Yes, there is a limit on visible characters in a cell.

You can enter 32767 chars but only 1024 will be visible or printed.

See Dave P's post for workaround.


Gord Dibben MS Excel MVP

On Fri, 27 Oct 2006 08:41:02 -0700, Dan @BCBS
wrote:

I've been using Excel many years actually since it came out.. But I cannot
beleive I have never seen this simple issue.
I'm typing along in a cell, the format is a simple General type. Then some
of the data I typed is cut off like it's truncated. I extend the cell up or
down still truncated. If I make the font real small my data appears, but I
need it bigger. Is there some kind of limit to the number of bits per cell.
ALso, I have already set the Wrap text.

Suggestions???