Forum Discussion

vvilar's avatar
vvilar
Copper Contributor
Oct 04, 2023

Currency Column Formatting not working as expected

Greetings, I have my database on MS Lists, and sometimes I need to export and send it to my coworkers, but I'm facing trouble with my currencies columns, when I export it they got many zeros that weren't expected. For example, that's my currency column on MS Lists: 

And that's the same column when I export it to excel.

I tried to set the column type to number, but trouble persists. Does anyone know how to fix it?

Thanks.

Lists
microsoft lists
SharePoint Online

2 Replies

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Oct 05, 2023

    Hi vvilar,

    1. 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.
    2. 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)

    • vvilar's avatar
      vvilar
      Copper Contributor
      Oct 06, 2023

      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.

       

Resources