How to fix Number formatting Europe / US

Ask the community
#1

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

#2

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

#3

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
#4

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

#6

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

2 Likes
#7

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
#8

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

#9

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.

#10

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