SOLVED

Custom Format number

%3CLINGO-SUB%20id%3D%22lingo-sub-1966801%22%20slang%3D%22en-US%22%3ECustom%20Format%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966801%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning!%20I%20am%20unable%20to%20create%20a%20conversion%20for%20a%20custom%20number.%20What%26nbsp%3BI%20mean%20is%20I%20have%20a%20slew%20of%20dates%2C%20such%20as%20620119%2C%20that%20I%20need%20to%20convert%20in%20Excel.%26nbsp%3B620119%20is%20actually%26nbsp%3Bis%20Jan.%201%2C%201962.%20Here%20is%20where%20it%20gets%20tricky%20-%20Rather%20than%20just%20converting%20620119%20to%2062%2F01%2F19%2C%20I%20need%20it%20to%20match%20prior%20work.%20What%20I%20want%20is%20to%20convert%20620119%20to%2001%2F19%2F62.%20Is%20that%20clear%3F%20Is%20that%20possible%3F%20H%20E%20L%20P%20!%20and%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1966801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966844%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Format%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966844%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F894707%22%20target%3D%22_blank%22%3E%40ProBowler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20a%20column%20with%20values%20such%20as%20620119.%3C%2FP%3E%0A%3CP%3EOn%20the%20Data%20tab%20of%20the%20ribbon%2C%20click%20Text%20to%20Columns.%3C%2FP%3E%0A%3CP%3EClick%20Next%20%26gt%3B%2C%20then%20click%20Next%20%26gt%3B%20again.%3C%2FP%3E%0A%3CP%3EIn%20step%203%2C%20select%20Date%2C%20and%20select%20YMD%20from%20the%20dropdown%20next%20to%20the%20Date%20check%20box.%3C%2FP%3E%0A%3CP%3EClick%20Finish.%3C%2FP%3E%0A%3CP%3EIf%20necessary%2C%20set%20the%20number%20format%20of%20the%20column%20to%20mm%2Fdd%2Fyy%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning! I am unable to create a conversion for a custom number. What I mean is I have a slew of dates, such as 620119, that I need to convert in Excel. 620119 is actually is Jan. 1, 1962. Here is where it gets tricky - Rather than just converting 620119 to 62/01/19, I need it to match prior work. What I want is to convert 620119 to 01/19/62. Is that clear? Is that possible? H E L P ! and thank you.

2 Replies
best response confirmed by ProBowler (New Contributor)
Solution

@ProBowler 

Select a column with values such as 620119.

On the Data tab of the ribbon, click Text to Columns.

Click Next >, then click Next > again.

In step 3, select Date, and select YMD from the dropdown next to the Date check box.

Click Finish.

If necessary, set the number format of the column to mm/dd/yy,

Incredible! I am sure this is 'old hat' to you, but to me it is outstanding. Much appreciated. What can i say but WOW!