Hi all,
I have a clear feeling I'm missing something fundamental here, so apologies in advance...
I have an excel spreadsheet containing 2 sheets:
1: Raw Data - The Raw data tab is formatted how I want it, i.e. Dates as dates, Numbers as numbers etc
2: Pivot Table - The Pivot table shows as it is in the raw data, however once I click on a value in the pivot (creating 'Sheet #' of raw data), the values are all in currency format.
I have tried using the 'clear formats' function in the raw data tab, and sure enough they are all currency....
So, to the question - How do I set the default format of these to be 'general' or 'Number' or anything else?
Thanks in advance.
Sam
I have a clear feeling I'm missing something fundamental here, so apologies in advance...
I have an excel spreadsheet containing 2 sheets:
1: Raw Data - The Raw data tab is formatted how I want it, i.e. Dates as dates, Numbers as numbers etc
2: Pivot Table - The Pivot table shows as it is in the raw data, however once I click on a value in the pivot (creating 'Sheet #' of raw data), the values are all in currency format.
I have tried using the 'clear formats' function in the raw data tab, and sure enough they are all currency....
So, to the question - How do I set the default format of these to be 'general' or 'Number' or anything else?
Thanks in advance.
Sam