Dec 15, 2020 02:10 PM
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
Dec 17, 2020 11:54 PM
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
Dec 18, 2020 06:34 AM
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.
Dec 19, 2020 05:02 AM
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
Dec 23, 2020 09:16 AM
It’s possible by creating a new formula field : SUBSTITUTE(CONCATENATE(Temps,""),".",",")
Jan 03, 2021 02:05 AM
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 ?
Jan 03, 2021 02:06 AM
Thx i will try but i think it won’t work if i can calculate with this fields
Jan 06, 2021 01:24 AM
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.