Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
Letter received and dispatch system
mahajong11 -
pcsces -

1 response