Previous Topic Next Topic

Date formate

Closed
akram786 Posts 7 Registration date Wednesday 30 April 2014 Status Member Last seen 30 June 2014 - 28 Jun 2014 à 00:31
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Jun 2014 à 06:25
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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
28 Jun 2014 à 06:25
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.

Similar discussions

Unable to change date format in Excel
rznbyz -
Tobby -

39 responses
How to change date format from yyyymmdd to mm/dd/yy in Excel?
lmw -
Sf -

12 responses
How to change date format in Excel?
Manikanta -
TrowaD -

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

11 responses
how to convert Date into text.
rk gupta -
TrowaD -

1 response