how to format a column with excelHtml5?

andres_ontiveros

Hi, I would like to know if I can format a column in .xlsx text only, I am new to this kind of thing. What happens is that a column that has serial numbers and the last digits are set to 0 because they are numbers (Image attached).

andres_ontiveros

get the result I needed with this https://datatables.net/extensions/buttons/examples/html5/outputFormat-function.html

hapi

When I was looking to format dates for Excel I again and again found this post, hence I would like to leave also a hint for how to format dates: https://datatables.net/forums/discussion/50616/what-is-the-correct-format-to-export-dates-with-html5-to-excel