Why is Excel truncating my text to 255 characters?


M

Mailjust4me

I created a simply spreadsheet in Excel 2007 but am saving as a 5.0/95
workbook to be sure the recipient can open it. Everything was fine until I
emailed it, and it immediately truncated every cell to contain just 255
characters! Now I can't recover the missing data and I am going out of my
mind!
 
Ad

Advertisements

J

Jacob Skaria

Thats the limitation with Excel upto version 7.0. You should have saved As
'Microsoft Excel 97-Excel 2003 & 5.0.95 Workbook (*.xls)' format
 
Ad

Advertisements

J

Jacob Skaria

Even 2000, 2002 and 2003 versions allows 32,767 characters (text); with 1024
characters displayed in cell..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top