Date format

[Closed]
Report
-
 Blocked Profile -
Hello,
i have date format like 20131203 (year month day) i want to change it as 03.12.2013.
please suggest


1 reply


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