Marketo CSV Reports / Number Formatting Issues / Percentages

Discussion created by 5c472654b29044c0ecb3ade8a76fdec210a429a3 on Aug 9, 2016
Latest reply on Aug 10, 2016 by 5c472654b29044c0ecb3ade8a76fdec210a429a3

Hi Everyone,


I have searched high and low, and I can't find the answer to this question. How can I export the data from my Marketo reports without percentages being a "custom" format number field instead of an actual percentage field? How about dates?


Every time I export my email performance reports and I copy/paste the rows into my "Master" excel spreadsheet with all of my different emails in it - all of the number formats get messed up. The long numbers don't have commas when they are in the thousands. Percentages aren't a percentage number format, so I can't sort my percentages... and dates aren't a date format, so I can't sort my date. I have to double click each day to get the field in Excel to turn into a date. All percentages, I have to re-type the percentage because a 99.9% will turn into 999.9% when I click % in the "number formatting" area in Excel.




Dates are "General" instead of "Date"


Percentages are "Custom" instead of "Percentage"



So, when I click a percentage and change the format to percentage (so I can actually use this field and write formulas, etc..) it changes to this:



Thank you if anyone has any help! I don't mind changing the numbers to have commas and no decimal places. But I don't know how to change these percentages without re-writing all of them.