ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table strange result (https://www.excelbanter.com/excel-discussion-misc-queries/132047-pivot-table-strange-result.html)

prufrock

Pivot table strange result
 
I have a pivot table which displays the characters "ms7" instead of
the number 12 actually stored in the database upon which the table is
based. Any other number displays correctly: 11.9, 12.1, 8, 9 etc.
For instance, the number 12 is displayed as "ms7". If the entry is
changed to 11, when the pivot table is refreshed, the 7ms changes to
11. I just don't get it.



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com