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
Highlighted
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
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
0 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
3 Replies