 | | |
| AlunD wrote: try concatenating ' with the date field, that should force it to be text | |
| | |
Okay. Good.
How do I do that, please?
| x404.co.uk http://www.x404.co.uk/forum/ |
|
| Spreadsheet date format question http://www.x404.co.uk/forum/viewtopic.php?f=4&t=386 |
Page 1 of 1 |
| Author: | HeatherKay [ Thu May 07, 2009 10:31 am ] |
| Post subject: | Spreadsheet date format question |
Me again. One for the Excel experts, I think. I have an Excel file, which I have to import into an InDesign table for making it look nice. I don't have MS Office, but do have Open Office 3. The file opens happily, I've done some tidying and saved. The file includes a column formatted for dd/mm/yy. When I import the file into InDesign, I get all kinds of options, and it creates a nice table for me to format. Except the date column is empty. My question is are there any other formatting options I can use to convert the date formats to plain text (I've tried to change the column format to plain text, but it seemed to assume it was a calculation and coughed up some strange result). Thank 'ee. |
|
| Author: | AlunD [ Thu May 07, 2009 10:44 am ] |
| Post subject: | Re: Spreadsheet date format question |
try concatenating ' with the date field, that should force it to be text |
|
| Author: | HeatherKay [ Thu May 07, 2009 10:47 am ] | |||||||||
| Post subject: | Re: Spreadsheet date format question | |||||||||
Okay. Good. How do I do that, please?
|
||||||||||
| Author: | big_D [ Thu May 07, 2009 10:51 am ] |
| Post subject: | Re: Spreadsheet date format question |
You could try copying it and then "Paste as text", might be under Paste Special... plain text. |
|
| Author: | HeatherKay [ Thu May 07, 2009 10:55 am ] | |||||||||
| Post subject: | Re: Spreadsheet date format question | |||||||||
That didn't work in the spreadsheet, sadly. It just pasted the formatting back in. 
|
||||||||||
| Author: | HeatherKay [ Thu May 07, 2009 11:28 am ] | |||||||||
| Post subject: | Re: Spreadsheet date format question | |||||||||
Let me clarify - I've got 200 date fields that I just was to export as text. I don't want to have to manually add a ' character in each field first. So, can I automate the addition of the character? Or can I force the formatting to be read properly? All I want is to dump the spreadsheet into InDesign and make it look pretty. Can it be this hard? No pressure, but I've got a client waiting on a proof for this thing now. 
|
||||||||||
| Author: | AlunD [ Thu May 07, 2009 11:39 am ] |
| Post subject: | Re: Spreadsheet date format question |
Heather can you mail me the sheet? |
|
| Author: | HeatherKay [ Thu May 07, 2009 11:43 am ] | |||||||||
| Post subject: | Re: Spreadsheet date format question | |||||||||
Thank you - but I've solved it now. *phew* I copied and pasted into a text document, which has imported to ID with no issues. Thank you for your offer, though. Much appreciated. Did I mention how much I hate spreadsheets? 
|
||||||||||
| Author: | AlunD [ Thu May 07, 2009 11:45 am ] |
| Post subject: | Re: Spreadsheet date format question |
Cool as long as its resolved. 
|
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|