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 > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > > > > > Hi Mike, > > > > Any version of MS Excel before version 12 has a maximum column and > > cell size of 255 characters. Depending on the data, and the specific > > version of Excel, anything over 255 characters will either be > > truncated or ignored. > > > > You can see a full list of Excel limits here: > > http://blogs.msdn.com/excel/archive/2005/9/26.aspx > > > > Regards - Harry > > > > > > At 06:26 AM 1/14/2006, Mike Reagan wrote: > > >Hi All > > >I am using Altium Designer SP4. Most of our designs have some > > >components which are used more than 50 times. (i.e. decoupling > > >capacitors). I have generated BOMs as CSV, text, and xls > > >outputs. Altium does a great job with any of these formats, however > > >when we import to into MSoft Excel, fields with large amounts of > > >characters such as the reference designators are omitted. The > > >problem is specific to MSOFT Excel since I have used other > > >spreadsheet programs like Quatro Pro. Has anyone else run > > into this problem? > > > > > > > > >Mike Reagan > > >EDSI > > SNIP > > > >____________________________________________________________ >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] ____________________________________________________________ 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]
