Forum Discussion
Problem with pivot tables and zip codes
KM_Date Sorry, now I see!
See attached. I copied your list and ran it through Text-to-columns and made Text of it all. Now in Column E and the pivot table beside it. I guess this is what you want.
KM_Date Sorry, now I see!
See attached. I copied your list and ran it through Text-to-columns and made Text of it all. Now in Column E and the pivot table beside it. I guess this is what you want.
- Thank you Riny_van_Eekelen. Can you tell me how "copying the list and running it through text-to-columns" differs from highlighting the list and changing the format to "text"? What should I do differently next time this happens? Also, can you tell me the steps you went through to "run it through text to columns"?
KM_Date If you format the column you intend to enter the ZIP codes in as Text before you manually enter the codes it should work. But entering a mix of numbers and text first and then format the column as text will not work. Excel merely left justifies what you entered, numbers and texts.
On the Data ribbon you'll find the icon for Text to columns. In step 3 of 3 you can indicate that you want to treat the data as text. That transforms all data a type of text. That's just the way it is.
And I'm afraid that the "data model" option is not for you as you indicated that you ar on a Mac.
- Thank you, this all makes sense. I'll do it that way next time! Thank you for your help!