Date formate

Closed
akram786
Posts
7
Registration date
Wednesday April 30, 2014
Status
Member
Last seen
June 30, 2014
- Jun 28, 2014 at 12:31 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jun 28, 2014 at 06:25 AM
i have 2 date formate example

06/11/2004
07-01-2004

and i want 1 formate and i useing this function

=text(CellAddress,"DD/MM/YY") and text(celladdress,""MM/DD/YY")

but not working in one column

i want use if condition in one cell and drag to all other cells

give me good idea


thanks

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jun 28, 2014 at 06:25 AM
your requirement is not clear.

in EXCEL dates must be ENTERED either as m/d/yy or d/m/yy depending of your configurations. see control panels-region and language-short date.

once you ENTER a date like this you can format as you like
in excel 2007 or later click
home
format
format cells

choose dates

many in built formats are available

if you want some other format not in built
choose "custom" instead of " date" and type how you want it.
0