[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

change 20141106 into 06/11/2014

Is there a way to change a [General] number like 20141106 into a date 06//11/2014

Thanks
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
Rory ArchibaldCommented:
With a formula, assuming that data is in A1:
=TEXT(A1,"0000-00-00")+0
0
 
JagwarmanAuthor Commented:
brilliant Rory, thanks
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now