I am creating a table that I need to then create a chart.  The data in the table is percentages.  The only way I can get the percentages to display correctly is if I select String as the data type.  This is causing two problems, I need to conditional format based on a data range which I cannot do using String and I need the data columns to be formatted as either integer or float to use in the chart.  How can I get either integer or float to display properly a percentage with two decimal places?  In the attached example the FTR column is set to integer, the PHT column is set to Float, and the others are set to string. The data source is an excel file.

Please disregard this ticket.  I continued to work on this after I created the ticket and have solved the problem.