Previous Topic Next Topic

Date formate

Closed
sabithpk - Jan 18, 2017 at 01:10 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jan 18, 2017 at 02:16 PM
Hello,

how to change the date format to 19-july-09

19.7.2009
23.04.2008
26.07.2010

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 18, 2017 at 02:16 PM
sabithpk, Good afternoon.

Supposing your data are at A1:A10

Select A1:A10
Click DATA Menu
TEXT to Column --> NEXT --> NEXT
Choose DATE (DMY)
OK

Now your data are a REAL DATE
Use DATE Format Menu to your desired format.(DD-MMMM-YY)

Is that what you want?
I hope it helps.
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