Hi, I have a column that has simple numbers, once pivot, the numbers switches to dates…
710 becomes 10-Dec-1901
660 becomes 21-Oct-1901
I can force the column to switch back to numbers… but I have 130 columns… only one of them does that… it’s kind of a long job to investigate all the columns !!!
I have version 5.9.7.5
Thanks.
I’m guessing that what is happening is that EasyMorph is changing how it displays the field rather than it changing the actual data.
If a column contains mostly numeric values that are in the range which means they could be dates, EasyMorph will default to showing them as dates. This only affects how we see the data when we are using EasyMorph. It doesn’t actually change the data as the data is transformed.
You can do Ctrl+click or Shift+click to select multiple (or all) columns and apply formatting at once to all selected columns.
