Convert text columns to numbers

[pineflatplace]

Hi

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

Thanks

[Expiscornovus]

Hi @pineflatplace,

You could first convert the string to float and then use the formatnumber function.

Try something like below:

formatNumber(float(item()['ExcelColumnName']), '0,0.00', 'en-us')

[pineflatplace]

Thanks Expiscornovus

Unfortunately that gives me an error "the expression is invalid"

[Expiscornovus · Accepted solution]

Hi @pineflatplace,

Can you share a screenshot of your setup and the expression you used? Can you double check if you used the correct Excel column name?

[pineflatplace]

Hi Expiscornovus

Apologies, I spotted my typo.