Change yyyymmdd format to mm/dd/yy in excel
Closed
Reset@123
Posts
1
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
Apr 8, 2014 at 03:15 AM
eladeb - May 17, 2015 at 10:47 AM
eladeb - May 17, 2015 at 10:47 AM
Related:
- Excel convert yyyymmdd to date
- Convert number to words in excel - Guide
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- Convert dts to ac3 mkvtoolnix - Guide
- Excel date format dd.mm.yyyy - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 8, 2014 at 08:13 AM
Apr 8, 2014 at 08:13 AM
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.
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.
May 17, 2015 at 10:47 AM
thanks.
***@***