How to fix Number formatting Europe / US

Hello,

I’m trying to import accounting from a CSV file in Airtable.

In the CSV file the number is formatted like this :
3240,50 (European format - Three thousand two hundred forty Euro and fifty Cents)

When i import in Airtable it become :
324,050.00 (US format)
(It can change depending on how i set up the decimal on the field)

The result is a wrong number so i can’t use it as it is.
I’m quite new on Airtable so i hope to find a quick fix.

Any help would be very appreciated.
Thanks

Hello @W_Vann_Hall,

I found Number and Currency ‘Pretty-Print’ Routines but it’s kind of too advanced for me and i’m not sure what to do with that.

Can you help me or at least point me to someone who can ?

Thanks

Hi @Ugo_Jauffret,

Not an expert on currency nor do I know if this will work, but perhaps you could try doing a “find” and “replace” in your sheet prior to importing. Find all “,” and replace with “.”

Not ideal. To my knowledge, Airtable doesn’t support the display of other currencies. Perhaps someone could help with a script to do this for you.

1 Like

Hi @Nathalie_Collins,

Thanks for you answer.

I tought about that too, as you said it’s not ideal but why not.
But it appears not as simple as that.

I tried and it doesn’t work.
From what i get it’s because you can’t do with “numbers” what you can do with “text”.
Again i’m quite new to Airtable and even spreadsheets so maybe i’m missing something obvious.

Thanks again @Nathalie_Collins

It’s possible by creating a new formula field : SUBSTITUTE(CONCATENATE(Temps,""),".",",")

2 Likes

Thanks.
If it becomes string text when using formula it becomes kind of useless for me.
I will have to find another tool.
I was so amazed by Airtable, this is
So deceptive.
Does anyone knows another tool ?

1 Like

Thx i will try but i think it won’t work if i can calculate with this fields

Merci @Rodolphe_Cantillon,
Est-il possible que tu me détailles un peu plus la démarche à suivre précisément.
Je suis très intéressé mais assez novice dans ce genre de manipulation et formules.
Merci d’avance.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.