Change yyyymmdd format to mm/dd/yy in excel [Closed]

Report
Posts
1
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
 eladeb -
Kindly give me guide to solve the change yyyymmdd format to mm/dd/yy in excel

Santosh Mane

1 reply

Posts
1873
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 31, 2021
139
Santosh Mane, Good morning.

Select the cell with the date.
--> Menu Format
--> Cells
--> Number
--> Custom
--> Below the word Type: on the field.
--> Type mm/dd/yy

Is it what you want?
I hope it helps.
is good, but the number can not be used to do date calculations, please he has a y-vba code that can be used.
thanks.
***@***

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!