Feb 12th, 2010, 9:46 PM
Hey Jim,
I may have to look at your other Excel problem tomorrow.
But on this one, it's definitely not Form Tools or the Export Manager module that's doing the conversion. I've encountered this before and I don't think it can be resolved from within Excel. Excel, once it's decide the column is a date column, there's no way to convince it otherwise.
Instead, you can tackle it via the Export Manager export type - you'll need to edit that Smarty markup to either reformat the field value right there, or maybe add a space at the end (or start) of the <td> cell. The latter is easier to do, so maybe give that a go first. That may be enough to convince Excel that it's just a plain string field.
Let me know how that goes. If still no luck, let me know.
- Ben
I may have to look at your other Excel problem tomorrow.
But on this one, it's definitely not Form Tools or the Export Manager module that's doing the conversion. I've encountered this before and I don't think it can be resolved from within Excel. Excel, once it's decide the column is a date column, there's no way to convince it otherwise.
Instead, you can tackle it via the Export Manager export type - you'll need to edit that Smarty markup to either reformat the field value right there, or maybe add a space at the end (or start) of the <td> cell. The latter is easier to do, so maybe give that a go first. That may be enough to convince Excel that it's just a plain string field.
Let me know how that goes. If still no luck, let me know.
- Ben