Excel Date Format

Closed
Rinku - Apr 27, 2011 at 08:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 27, 2011 at 09:44 PM
Hello,

In the Excel sheet I have dates are in the format dd/mm/yyyy.
How do I format it to be yyyymmdd ? .


Your quick responce will be much appriciated.

Thanks a lot in advance!




Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 27, 2011 at 09:44 PM
select the cell
click format-cells-customformat
in the top window type
yyyymmdd
and cllick OK
0