Forum Discussion
We verified this is a problem with excel which Microsoft acknowledges here http://support.microsoft.com/kb/213841
Excel truncates the field when it opens it - which is weird because you can type much more info into a cell in excel than 255 chars.
There is a workaround - select the Format "Tab-Delimited Values" when you export from Quickbase. Open a blank spreadsheet and format the column that will contain the long text as Text. Then open the file you exported with a plain text editor such as Notepad (recommend not using MS Word) and copy and paste the contents back into Excel. Thanks to Tim Phan of CH2M Hill for the workaround.
Excel truncates the field when it opens it - which is weird because you can type much more info into a cell in excel than 255 chars.
There is a workaround - select the Format "Tab-Delimited Values" when you export from Quickbase. Open a blank spreadsheet and format the column that will contain the long text as Text. Then open the file you exported with a plain text editor such as Notepad (recommend not using MS Word) and copy and paste the contents back into Excel. Thanks to Tim Phan of CH2M Hill for the workaround.