Hi, sorry if my question seems very basic-I've only started using excel in the last week with my new job.
I've been sent a table and I need to group dates with results. When I'm on my main spread sheet the results
look like they're in number format (some are <10, others are 1000, 2000 etc). When I go to my pivot table, the results
are appearing in date format as opposed to numbers. I've tried to format the cells in the main spreadsheet and put formatted
them all as general but they're still appearing as dates when I do my pivot table even after that. Is there something that I'm missing?
Thanks so much for your help
I've been sent a table and I need to group dates with results. When I'm on my main spread sheet the results
look like they're in number format (some are <10, others are 1000, 2000 etc). When I go to my pivot table, the results
are appearing in date format as opposed to numbers. I've tried to format the cells in the main spreadsheet and put formatted
them all as general but they're still appearing as dates when I do my pivot table even after that. Is there something that I'm missing?
Thanks so much for your help