megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 139
- Office Version
- 365
- Platform
- Windows
We are on Office 365 and this has only started happening recently (last couple of months) so I don't know if it's due to a Microsoft update.
Excel keeps formatting dollar amounts in regular data ranges and Pivot Tables as dates. See screenshots from this workbook, which is years old and has been updated thousands of times with data always in this format and never done this before.
I have changed font color to white in some areas to preserve privacy and anonymity - they are just "general" format labels.
Here's a pivot table where the number is correctly formatted as a number:
When I double click on the $33,863 to view the detail, you can see B4 has a mm/dd/yyyy format (the date of the check) but Excel is displaying it as "Feb-18".
The amounts are formatted as mmm-yy even though the source data is a number and is formatted as a number.
When I click on one and choose the $ sign (accounting) number format, it shows the number as it should.
This same problem is occurring with all other workbooks and on other computers (like my boss', who accesses and updates these same workbooks). I've changed those grey reference numbers in the first two screenshots a hundred times and it always goes back to that. HELP!
Excel keeps formatting dollar amounts in regular data ranges and Pivot Tables as dates. See screenshots from this workbook, which is years old and has been updated thousands of times with data always in this format and never done this before.
I have changed font color to white in some areas to preserve privacy and anonymity - they are just "general" format labels.
Here's a pivot table where the number is correctly formatted as a number:
When I double click on the $33,863 to view the detail, you can see B4 has a mm/dd/yyyy format (the date of the check) but Excel is displaying it as "Feb-18".
The amounts are formatted as mmm-yy even though the source data is a number and is formatted as a number.
When I click on one and choose the $ sign (accounting) number format, it shows the number as it should.
This same problem is occurring with all other workbooks and on other computers (like my boss', who accesses and updates these same workbooks). I've changed those grey reference numbers in the first two screenshots a hundred times and it always goes back to that. HELP!
