Hi Harry,
Sorry, I should have taken more time to read your post.
I have Office 2002 and it has the limit I posted, and
from the version number looks to be office 10. Seems
like the blog is not completely correct, unless I'm
missing something.
These are bits from that blog, looks to me like depending
on the cell format it can still display 1k characters.
The total number of characters that can display in a cell
Old Limit: 1k (when the text is formatted)
New Limit: 32k or as many as will fit in the cell (regardless of
formatting)
The number of characters per cell that Excel can print
Old Limit: 1k
New Limit: 32k
The number of characters that can be stored and displayed in a
cell formatted as Text
Old Limit: 255
New Limit: 32k
Regards,
Darren Moore
> -----Original Message-----
> From: [EMAIL PROTECTED]
>
>
> Hi Darren,
>
> As I said in my posting, that is true ONLY if you have Excel Version
> 12, or newer. Version 12 is the one you find in Office 2003.
>
> Mike didn't say what version of Office or Excel he is running. I was
> only trying to point out the possible source of the problem if he is
> running a version of Excel older than that found in Office 2003. The
> MS blog page I referenced in my post shows both the old and new
> limits of Excel.
>
> Regards - Harry
>
>
> At 10:49 PM 1/14/2006, you wrote:
>
> >Hi Harry,
> >
> >I think you will find the limit is 1024 chars per
> >cell, and if I remember it's a display limit only.
> >
> > >From the Excel 2002 help...
> >
> > Length of cell contents (text) 32,767 characters.
> > Only 1,024 display in a cell; all 32,767 display
> > in the formula bar.
> >
> >Note, changing the format for the cell to 'General'
> >I think it is, can help display the cell contents
> >that was set to 'text' ?? (something like that anyway)
> >
> >
> >Darren Moore
> >
____________________________________________________________
You are subscribed to the PEDA discussion forum
To Post messages:
mailto:[email protected]
Unsubscribe and Other Options:
http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004):
http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current):
http://www.mail-archive.com/[email protected]
