Date format

Closed
soni - Apr 23, 2015 at 08:26 AM
 Blocked Profile - Apr 23, 2015 at 08:46 AM
Hello,
i have date format like 20131203 (year month day) i want to change it as 03.12.2013.
please suggest


Related:

1 response

Blocked Profile
Apr 23, 2015 at 08:46 AM
Hello,

click on the cell(s)

then right click and go to "Format cells"

under the "Numbers" tab click "Custom"

Type dd.mm.yyyy and press OK
0