Number to date conversion

drluke

Active Member
Joined
Apr 17, 2014
Messages
283
In A1 I have 43244 Software Application. I want it to be 24/05/18 Software Application.

I thought combining TEXT and LEFT would work but it doesn't.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,822
Office Version
2010
Platform
Windows
Here is another formula that will also work...

=REPLACE(A1,1,5,TEXT(LEFT(A1,5),"dd/mm/yy"))
 

Watch MrExcel Video

Forum statistics

Threads
1,096,458
Messages
5,450,574
Members
405,619
Latest member
mjh237

This Week's Hot Topics

Top