hyphened values displayed wrong in Excel Export
Permalink Browser Info Environment
I noticed when entering dashed values in the exact format like x-xxxx, Excel converts it to a date. For example, when a form has a Text Field value of 2-2345, Excel converts it to Feb-45. Unfortunately this format is needed because the client's product serial numbers are formatted that way.
What's the best way to fix this? I'm not sure if the problem is from Excel or something in C5.
What's the best way to fix this? I'm not sure if the problem is from Excel or something in C5.
| Type: | Discussion |
|---|---|
| Status: | New |
Just discovered that Excel is just like that. Er, what controls the export to excel function? The only workaround I can think of is just slipping an apostrophe so that Excel would leave my x-xxxx values alone. :P
I added a non-breaking space in line 148 of file
Works for now :)
extended_form\controllers\dashboard\reports\extended_form.phpWorks for now :)
Thanks for the helpful thread.