View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default truncation of fields inported from access

On Aug 18, 4:18 pm, liddleti
wrote:
How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text.


Try formatting the cells as General. Versions as old as Excel 2000 can
have far more characters than this in a cell, but you may need to
change out of Text format, I forget exactly how this works.

Excel 2007 is unlimited or something like that, if upgrading is an
option.