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
Highlighted

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

 

Can you post a screenshot?

Highlighted

@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
Linking
Rick0302 in Excel on
2 Replies
Anyone good at custom format? Please help
Kaneszc in Excel on
1 Replies
Show Blank or Zero
I_B_C in Excel on
3 Replies
Duplicate Billing
Kay_T1060 in Excel on
2 Replies
formuale help
Gavc1 in Excel on
2 Replies
searching a sheet with a true and false function
Aaron_excel in Excel on
5 Replies