Regional Number format
Hello,
In your regional preferences, you have predefined South Africa's English settings as :
Apparently when we adopted decimal system many moons ago, the decimal separator changed to a comma, but honestly I dont know anyone here that uses a comma as the decimal separator. we use a full stop (period) like most of the other English options.
I would simply select one of the other english options that does have the full stop (period) separator, but none of them have our date format as shown above (CCYY/MM/DD) . . .
how do I get round this in settings ? I would prefer not some manual conversion on every number / date column in all my sheets etc.
Kind Regards,
Wesley.
Answers
-
Thank you for pointing this out! I have passed along your feedback to our Product team so they're aware of your situation. If you'd like to submit this feedback yourself, please feel free to use this form, here.
At this time there is no way to have the unique combination of (CCYY/MM/DD) and a number format with a period as your default settings, however you could choose a different English setting with the period, then adjust your date columns in your sheets to show the long date, instead (see here):
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives