How to convert USD to Canadian Dollars format in Smartsheet ?
Please help me to figure how to convert USD to Canadian Dollars format in Smartsheet ?
Also, does it depend on user setting or sheet settings?
Answers
-
Good evening,
Try changing your language settings, below.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hey Mark,
Based on your solution, I tried to change Personal Settings and found following for Toronto Time zone.
Is this the reason my file is showing USD$ values ?
Also, would like to know how can this be fixed ?
Thank you!!
-
The time zone and regional settings in your personal account are supposed to set number formats. There isn't a Canadian region so I'm curious to find out if the Toronto time zone changes the currency. Let me know.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!
