Date formatting in dd/mm/yyyySolved/Closed

Question

Hello,

I have got dates typed in the format following 01.08.98  and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.
System Configuration: Windows XP Internet Explorer 6.0

NICK · Accepted Answer

Hi, 

 Just use replace function under EDIT/REPLACE or press Ctrl+H. 
 Replace the . (dot) by a forward slash /  .
 Then you will be able to change the format.
 If not, copy the result and paste it again in the column to force Excel to recalculate cells.
Good luck.

john · Answer

Hi , please use data text to columns to seprate the values and the use the date function to create the format you desire.

Vaishu · Answer

Use replace all function... Replace all '.' with '-'.
The format will change.

Balaji · Answer

If it is in YYYYMMDD format
select the column go to DATA TAB 
select text to columns
give two next and in third one select date radio button and select YMD format this will be converted to D/M/YYYY format dont get panic
now select the same row with d/m/yyyy format and right click and select fomat cells in that select date in locale select english(u.k) browse for any date option on top and select it....
simple now YYYYYMMDD converted to YYYY-MM-DD

Balaji Raghunathan

shil · Answer

Instead of 01.05.2010 I need 01/05/2010. But while typing 01/05/2010 it takes 5th date of Jan mont h year as 2010.So how to do this pls help me.

Date formatting in dd/mm/yyyy

5 replies

Similar discussions

Subscribe To Our Newsletter!