Is there an easy way to convert text to numbers prior to creating HTML table, so that they appear right justified and with correct decimal places?
The original source data is from an Excel spreadsheet.
I am using a Select and using item()['ExcelColumnName'] to extract the data, but it creates a text value not a numeric value.
I tried FormatNumber, but it expects the input to be a number, not a string
Solved! Go to Solution.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.