Home

Setting format for imported data from Sharepoint

pje_123
Occasional Visitor

I have data being imported from SharePoint, and like a few other posts it is pulling over in text format.

In my excel sheet I am using project dates from the imported and IF formulas to provide a value however the forumals aren't recognising the dates as dates, showing values in " " when I evaluate the formula.  How do I set the text in the SharePoint data to be viewed as a date without the need to use text to columns manually each time someone opens the document which would be a huge task. 

 

Any help would be greatly appreciated - even if I need to create a separate excel sheet first and pull from there instead.

 

Cheers 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies