<div>
thanks, I found out in the editing of the script to change from datetime to date. &nbsp;did the trick.
</div>


thanks, I found out in the editing of the script to change from datetime to date.  did the trick.

<div>
<div class="content wysiwyg-content">
How do I prevent the date value from being converted back to a Serial when Power Query creates the Pivot Data.<br />
<br />
IE. &nbsp;7/1/2014 - 45323<br />
<br />
This is using the Power Query tool within Excel
</div>
</div>


How do I prevent the date value from being converted back to a Serial when Power Query creates the Pivot Data.

IE.  7/1/2014 - 45323

This is using the Power Query tool within Excel

PowerPivot -Query Editor -  Convert Date

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.