CRM

MKröner7
Member

Import Numbers - Decimal Separator Problem

Hi there, 

I am curious if someone else is facing this problem when importing numbers: 

 

Our account is set to the German, so our decimal separator is a comma. When I import a excel file with numbers using the comma as separator, I still have to select the US number format during the import, otherwise the numbers will be imported with the dot as decimal separator. 

Currently we have to be very careful with all number properties, because there are different ways to handle this issue depending on the type of contact creation or update: 

a) Via the UI: we are using the comma as separator
b) Via API (Zapier): only dot can be used as separator 
c) Import: import with comma but tell hubspot that it's a dot

Does anyone have the same or similar problems? 

0 Upvotes
1 Reply 1
MiaSrebrnjak
Community Manager
Community Manager

Import Numbers - Decimal Separator Problem

Hi @MKröner7

 

Thank you for reaching out to the Community!

I wanted to tag in a couple of subject matter experts to see if they have any input on this matter:

Hi @franksteiner79@fabianschmidt@mariomaier, have you encountered a similar behaviour? Thank you!

 

Cheers
Mia, Community Team    


Wusstest du, dass es auch eine DACH-Community gibt?
Nimm an regionalen Unterhaltungen teil, indem du deine Spracheinstellungen änderst


Did you know that the Community is available in other languages?
Join regional conversations by
changing your language settings

0 Upvotes