Exporting a dollars column to Excel
Exporting a dollars column to Excel
WebDevBeginner
Posts: 1Questions: 1Answers: 0
I have a costs column where the data is formatted as follows:
<td>$6,011.65</td>
I'm using the Buttons extension to add the export to excel functionality but I'd like the exported costs column to have the $ stripped away. Is there a way to strip this as part of the export or am I best adding an extra hidden column with the formatted data and export that instead?
This discussion has been closed.