I have a data column with values like 703.1667. And it shows “703.1667” no matter what format I tell it to use suach as “#,##0” or “#,##0%” What am i missing to make the data conform to the format?
I am pulling the data from a My SQL data base with the following query:
SELECT goodlbs/schHrs as lbsPerSchHour
FROM OEE_EFoutputByRun as lbs
LEFT JOIN OEE_TimeSummaryByRun AS timeSum
ON timeSum.idMachineRuns = lbs.idMachineRuns
WHERE schHrs > 0