| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel truncating my text to 255 characters?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is Excel truncating my text to 255 characters?
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 -- Jacob (MVP - Excel) "Mailjust4me" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trimming/Truncating Text Field in Excel | Excel Discussion (Misc queries) | |||
| EXCEL: Truncating Text Fields to allow Vlookup searches to find da | Excel Worksheet Functions | |||
| Intentionally truncating text characters | Excel Discussion (Misc queries) | |||
| truncating a colum to 55 characters | Excel Discussion (Misc queries) | |||
| Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
Linear Mode
