It looks like your second screenshot is in Excel. I believe this is an issue of how column B is being formatted in Excel. Can you please test right clicking on the “B” at the top of column B and selecting “Format Cells”, then select “Text” or “General” for the format type of that cell?
Does this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
Thanks for testing that out! Can you please provide what values you are expecting to see in the cells where the incorrect values are being returned? In addition, can you clarify if this column is using a calculation to determine the values in that column? Lastly, can you also test changing the column format to General instead of Text?