Forum Discussion
Currency Column Formatting not working as expected
Hi vvilar,
- Make sure that the regional settings on your computer match the currency format that you want to use when exporting your list. You can check this by going to Settings > Time & language > Region and making sure that the Currency format setting is correct.
- When exporting your list, make sure to select the Excel format. This will ensure that the currency formatting is preserved when you open the exported file in Excel.
If you are still having problems, try using a different currency formatting string in the Column settings for your currency column in MS Lists. For example, to use the Brazilian real currency format, you would use the following string:
R$#,###.00
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
LeonPavesic, thanks for your reply.
I checked my computer's settings and currency format is ok and I'm already using Brazilian currency format in MS List column settings.
When I try to export selecting excel format, it keeps bringing me all those zeros again, but when I select CSV format it brings correct format, but also brings some errors because of Brazilian accents on some works.
So I'm still trying to find out a solution.