Home

Problem with Excel 365 with text data changing to numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-550210%22%20slang%3D%22en-US%22%3EProblem%20with%20Excel%20365%20with%20text%20data%20changing%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550210%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20co-workers%20using%26nbsp%3BExcel%20365%20updating%20the%20same%20document.%26nbsp%3B%20Some%20users%20know%20what%20they%20are%20doing%20%26amp%3B%20some%20do%20not%2C%20which%20might%20be%20the%20root%20of%20the%20problem.%20On%20some%20of%20their%20pivot%20tables%20where%20the%20data%20set%20displays%20text%2C%20when%20pulled%20into%20rows%20of%20the%20pivot%20table%2C%20the%20data%20is%20switched%20to%20numbers%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edata%20set%20reads%20as%20EX5A%2C%20but%26nbsp%3B%20changes%20to%200.4%3C%2FP%3E%3CP%3Edata%20set%20reads%20as%20MORTL%2C%20but%26nbsp%3B%20changes%20to%209.26%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20figure%20out%20why%20this%20is%20happening.%26nbsp%3B%20Please%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550219%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Excel%20365%20with%20text%20data%20changing%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550219%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338626%22%20target%3D%22_blank%22%3E%40ChristineImpy%3C%2FA%3E%26nbsp%3B%2C%20I%20don't%20understand%20what%20you%20mean%20with%20%22data%20set%20reads%20as%20EX5A%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20post%20a%20screenshot%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550263%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Excel%20365%20with%20text%20data%20changing%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550371%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20Excel%20365%20with%20text%20data%20changing%20to%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338626%22%20target%3D%22_blank%22%3E%40ChristineImpy%3C%2FA%3E%26nbsp%3BCan%20you%20also%20post%20a%20screenshot%20of%20the%20pivot%20table%20setup%3F%20The%20Rows%20section%20of%20the%20pivot%20field%20list%3F%20like%20this%20one%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20284px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112652i4FE5AC4CA74AEBEF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-05-09_10-25-38.png%22%20title%3D%222019-05-09_10-25-38.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20also%20a%20screenshot%20of%20the%20resulting%20pivot%20table%20where%20that%20weird%20value%20is%20showing%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20really%20don't%20understand%20what%20the%20issue%20is.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
ChristineImpy
New Contributor

I have several co-workers using Excel 365 updating the same document.  Some users know what they are doing & some do not, which might be the root of the problem. On some of their pivot tables where the data set displays text, when pulled into rows of the pivot table, the data is switched to numbers:

 

data set reads as EX5A, but  changes to 0.4

data set reads as MORTL, but  changes to 9.26

 

I cannot figure out why this is happening.  Please help

 

3 Replies

@ChristineImpy , I don't understand what you mean with "data set reads as EX5A"

 

Can you post a screenshot?

@ChristineImpy Can you also post a screenshot of the pivot table setup? The Rows section of the pivot field list? like this one

 

2019-05-09_10-25-38.png

 

 

And also a screenshot of the resulting pivot table where that weird value is showing?

 

I really don't understand what the issue is. 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies