Get & Transform Data Formatting Issue

[Dan_B]

Hi Everyone

I have 2 spreadsheets 1 = SOURCE DATA and 2 = REPORT OUTPUT both created in Excel 2017

I've updated my source data with some new lines (which include the same formula as the old lines) but now when I refresh the data in the report output spreadsheet the date format is coming out as a numeric value instead of a date value despite the formatting showing as "Date" in both

I've tried amending the formatting again in the source data but nothing seems to work

Does anyone know why this happens and what I can do to fix it?

Thanks

Dan_B

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.