Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to convert a number to a string ? (Problem with decimals)

Topic Labels: Formulas
797 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,

Unfortunately, I’ve a problem when I CONCATENATE(Montant HTVA)
Capture d’écran 2021-03-04 à 11.49.09

As you can see, I have decimals that appears from nowhere :frowning: I need to convert my prices into string to be able to generate an invoice that include all my items lines.

How can I solve that problem?

4 Replies 4

Hey @Beerfood_hello

Instead of
CONCATENATE(Montant HTVA) use ROUND(Montant HTVA,2)

Thanks for your answer, but it doesn’t works :confused: When I use it for “Montant HTVA”, it shows only the integral number

Make sure to update the formatting to show decimal places.
Then you’d need to another formula field to “join” the values if you need the EURO sign at the end.

I replicated your example and fully expected to get a sensible result, unlike yours. But no, I got those weird trailing decimal places as well.

ROUND doesn’t work as you would expect either. I think there’s something going on under the hood with floating point variables.

What you are trying to do should be possible and work as you would expect.