Hi
I have a pivot table and when I right click on any cell inside my pivot table I see 2 options
- Format cells
- Number format
What is the difference these 2 options? I tried both and they are the same to me? Thank you very much.
Hi
I have a pivot table and when I right click on any cell inside my pivot table I see 2 options
- Format cells
- Number format
What is the difference these 2 options? I tried both and they are the same to me? Thank you very much.
In my files using the 2019 version of Excel, when I select format cells only the active cell formats, whereas when I select number format all of the cells in the field format.
Perhaps that behavior has been changed in the newer versions (i.e. 365).
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks