Previous Topic Next Topic

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 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
Excel format
D -
sheryljohnson -

1 response
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses
enter date in dd-mm-yyyy
sam -
fdibbins -

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

11 responses