Values (html table displayed in excel format) not sorted numerically
I have this JSP which retrieves data from the database and formats them in html table format. The table contents are then displayed in an excel application in the browser. Users can save the excel file from the browser menu.
Is there any way to define the cell's datatype as "general" or "numeric" so that the values are sorted numerically and not alphabetically?