1 person found this helpful
Local formatting should be done in EXCEL and transformed to text,not values, I normally copy all cells into a new sheet, defined all cells as text and import that.
Problem is that InDesign does not respect other settings than US. E.g. if I have a date in German Form "DD.MM.YYYY" or international Form "YYYY-MM-DD" or in German long form "D. MMMM YYYY, dddd" everything changes to "MM/DD/YYYY". So the only way is to import not values from Excel but text cells (which looks the very same in Excel on the screen).
Thanks. For clarification, the prices in Excel are text, they are not formulas. I will investigate formatting the prices in Excel.
Any help on my first problem would be gratefully received.
Anyone got any pointers on my first problem? Thanks.
I told you what to do. If you get this problems then it is because it is NOT text, it is data formated by the presets of the OS in Excel, but you have to get rid of the OS formatting in Excel, even if it looks alike the very same.
Thanks Willi - but your answer is to my second problem. My first problem is as shown in my original post.
I would do this:
- Create on line with the formatting.
- Export as InDesign tagged text (TXT)
- Read out these tags
- In Excel exists a function to connect text from several cells and predfined text, there connect the content from cells with the paragraph styling tags. Do it in a seperate sheet. (Better would be to use a database like Access, there you can link your Excel sheet).
- Export this sheet as txt file
- Place this sheet as tagged text (there is an option in one of the sialog boxes).
- In preferences < file handling you can specify that Tablecalculation Sheets and text is not embedded but linked, turn it on.