help with formatting pivot table

RebeccaF

New Member
Joined
Jun 10, 2021
Messages
5
Office Version
  1. 2007
Platform
  1. Windows
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
1,657
Office Version
  1. 365
Platform
  1. Windows
What happens if you right click in any of the cells in the pivot containing a date and select "field settings" then "Number format" and then choose one of the number formats ?
 

RebeccaF

New Member
Joined
Jun 10, 2021
Messages
5
Office Version
  1. 2007
Platform
  1. Windows
What happens if you right click in any of the cells in the pivot containing a date and select "field settings" then "Number format" and then choose one of the number formats ?
Thanks so much-unfortunately that didn't seem to resolve it. Not sure what the issue is with it
 

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
1,657
Office Version
  1. 365
Platform
  1. Windows
Can you show a picture of what the number/date looks like:
  • in the pivot table
  • in the original table
  • show a copy of the Pivot Table Fields pane (normally on the right side)
  • Maybe a picture of the field settings dialogue box for that field
Is your profile correct, are you using Office 2007 ?

I'm in Australia which is not the ideal time zone for you.
 

RebeccaF

New Member
Joined
Jun 10, 2021
Messages
5
Office Version
  1. 2007
Platform
  1. Windows
Hi Alex
Thanks again for your help. I tried your original suggestion on a different computer last night and it worked! Thanks so much!
Yes it's Office 2007 (it's the only one available to me when I'm working from home remotely). I think that they said that they were going to update it soon!
 

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
1,657
Office Version
  1. 365
Platform
  1. Windows
Thanks for letting me know. Glad you got it working.
I expect it should be similar on 2007 but I don't have a copy to try it on.
 

Forum statistics

Threads
1,141,062
Messages
5,704,057
Members
421,325
Latest member
tapete86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top