Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I have a spreadsheet that a client created so I could import text into InDesign. One column has paragraph-length text entries, and they won't display as text or export either (only the short ones do). I've tried Autofit, shrinking the type manually, merging cells, making them max width, reducing the type size - everything I can find to try. Even when I export to a .csv file, or copy/paste to Word, I still get the ###s. I have 69 rows of data to import; I hate to think I have to copy/paste them from the formula bar one at a time. <br><br>Any one know a way to fix this?
|
|
0
|
|
|
|
Reply
|
 mchak
|
11/4/2009 3:45:45 PM |
|
Thanks for the reply. The ###s display in the cell; and they're there in the .csv export, and when I import using InData into InDesign they come in as well. <br>
Smaller text lines with only 1-line across of text display; but the longer entries don't. I can see the text in the formula bar, but can't export it. <br><br>I made the columns as wide as I could (21") and that didn't help; I tried autofitting and making the text really small - still no go. <br><br>However, I DID solve my problem by opening the .xls file with Word and allowing it to use it's own import filter . . . it built a table with all the text showing. So, then I exported that to a text file and could import it as tab-delimited. But this is a clumsy workaround I shouldn't have to do.
|
|
|
0
|
|
|
|
Reply
|
mchak
|
11/4/2009 7:18:10 PM
|
|
Can you check the formatting of these cells showing ###? If it's set to "text", try set it to "general" instead. Please let me know whether it works. <br><br>Thanks, <br>
XinXin <br>
Macintosh Business Unit, Microsoft <br><br>This posting is provided "AS IS" with no warranties, and confers no rights. <br><br>> I have a spreadsheet that a client created so I could import text into InDesign. One column has paragraph-length text entries, and they won't display as text or export either (only the short ones do). I've tried Autofit, shrinking the type manually, merging cells, making them max width, reducing the type size - everything I can find to try. Even when I export to a .csv file, or copy/paste to Word, I still get the ###s. I have 69 rows of data to import; I hate to think I have to copy/paste them from the formula bar one at a time. <br>
> <br>
> Any one know a way to fix this?
|
|
|
0
|
|
|
|
Reply
|
XinXin
|
11/5/2009 2:28:17 AM
|
|
|
2 Replies
202 Views
(page loaded in 0.148 seconds)
Similiar Articles: TransferText acExportDelim unexpectedly truncates numeric field ...... as text during export to a > text file. > One work around is to export a query instead of a ... for TheNumberField, uncheck the Show CheckBox > > Export the query instead of ... Rendering word reports using XML and XSL to generate Word XML ...... issues like 1/ Display rich text - Suppose we have HTML tags in the text they are thrown out on the word document as text instead of rich text 2/ Charts - Export ... Automate a import, sort, and export - microsoft.public.access ...Macro that exports the csv (transfer text) 3. I cant figure ... Import/Export Text Specification - microsoft.public ... I am trying to automate data import, instead of ... Import CSV file into Project with Hard Returns - microsoft.public ...I have tried \r\n but that shows up as actual text instead ... Project will only display a maximum of 255 character ... How do you Export the MS word 2007 Document map to a ... PowerPoint Corruption Error Message - microsoft.public.powerpoint ...... error messages in PowerPoint which > say "PowerPoint was unable to display some of the text ... the above error message when I tried to open a file ... instead of ... Export MS Access report to single html - microsoft.public.access ...... everything into one html document instead of ... report in RTF - Pictures do not display ... I know in ... I export ... MS ACCESS REPORT EXPORT TO TEXT FILE - microsoft ... Export Global Group Members samacountname(s) to Text File ...... samid Otherwise, a VBScript program can show ... Instead, you must use ADO to retrieve all users ... Global Group Members samacountname(s) to Text File ... Export user ... Can you turn off word wrap when pasting into Excel?? - microsoft ...have you tried to export the query to excel instead of copy and paste? I cant remember if you get the same result (wrapped text) as I quit working with access to excel . Save as PNG makes everything fuzzy. Trying to create Certificate ...... great, but when I save as PNG, all the text ... on how you'll use the certificate) export as WMF or EMF instead to ... Unable to create certificate chain - microsoft ... file export of report ... "Yes/No" data type fields ...... thing to do is simply run the query instead of ... Unable to Export a SSRS 2008 report to PDF - microsoft ... Export data to a text file - Access - Office.com... file when ... Export data to Excel - Access - Office.comYou do this by using the Export Wizard in Office Access ... hyperlink fields, the contents are exported as a text ... Open the destination Excel workbook, and then display the ... Export data to a text file - Access - Office.comThis topic explains how to export text files by using the Export Wizard in Microsoft ... file that the process creates, the amount of data that is exported, and the display ... xhost: unable to open display - Database Support @ dbaspot.com ...... but it failed: # DISPLAY=tserver1:0 # export DISPLAY ... > xhost: unable to open display "tserver:0" > > Note, tserver is ... try to avoid it, and use xauth cookies instead. ... Access 2007 Export to Text File with Fixed Length Error - BugAccess 2003 Text Export shows like this (Correct): ... This is a fixed width export Instead of data01/01 ... I got an error ("Access was unable to append all ... iBooks 1.1 doesn’t deliver what Apple promises | TheTechJournalibooks pdf export write notes on ibook I cant see the text in ibooks IBOOK CANNOT SHOW ... ibooks unable to open pdf export iBook highlights iphone show pdf ... Australia, Instead ... 7/25/2012 9:13:52 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14 followers. 