Thousand separators Europe
under review
A
Albane
Hello,
When European properties extract the pace report, numbers are formatted for American numbers: i.e., thousands separators are done with commas whereas European numbers separate thousands with ".".
When they try to replace all with nothing to remove the comma, it removes the 0s on some numbers , i.e. "4,830" would become "483".
Can this please be changed?
Thank you
P
Pia Nielsen
under review
Hi Albane,
Thanks for this. Two things:
- Have you tried changing the regional settings on the local pc to see if this can fix it when the file is opened in Excel?
2.To confirm, for European hotels; export, you would prefer to have the European thousand separator (.) instead of a comma, and decimal separator to be , instead of . , correct? This applies to all of your European hotels?
Thank you!
A
Albane
Pia Nielsen Hi Pia,
Thank you for this, sorry I didn't get to respond before.
I just transferred your suggestion to the hotel, let me see for an answer. I have not heard back about this since so nothing urgent for now!
Thank you,
Albane