Home

Setting format for imported data from Sharepoint

Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies