The formula to convert text to a number works in one table, but not in another?

Feedback
1

image
image868×1582 97.3 KB

Can you help me understand what’s wrong with the formula in this case?

2

The tonumber function only works for numbers with the dot as a decimal separator, without any spaces, and without any other characters like the currency symbol.

You have two options here:

  • Store numbers as numbers and not a text and use the “Number formatting” feature that is now under development. This would allow you to display such numbers with currency symbols and thousand separator without working with text.
  • Process your text first with replace function, replacing the separators and currency symbols. After that you will be able to use the tonumber to convert it.

Hope it helps!

1 Like