Excel conversion [Closed]

Report
Posts
1
Registration date
Monday August 6, 2012
Status
Member
Last seen
August 6, 2012
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!