Previous Topic Next Topic

Excel conversion

Closed
pete3566
Posts
1
Registration date
Monday August 6, 2012
Status
Member
Last seen
August 6, 2012
 - Aug 6, 2012 at 11:15 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 - Aug 8, 2012 at 12:02 AM
Hello,
Need assistance setting up a formula to change this format yyyymmdd to mm/dd/yyyy. Is there someone who can provide step by step instructions?? Thanks,


1 reply

Answer 1 / 1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 808
Aug 8, 2012 at 12:02 AM
how did you enter the data in excel (as EXCEL DAT according to regional convention) or did you just enter it just as a number

suppose you have entered as EXCEL DATE
you format-cells-custom
type
mm/dd/yy and hit ok

if you have typed it as number e.g. 20120808 thsen

in another cell type
=(MID(E73,5,2)&"/"&RIGHT(E73,2)&"/"&LEFT(E73,2))*1
E73 is the cell where the date is .l you modify the formula
(this is according to my regional date entry convention that is m/d/yy

ALWAYS ENTER DATE AS EXCEL DATE ACCORDING TO YOUR REGIONAL CONVENTION. THEN IT IS EASY TO MANIPULATE.
0