Menu
Ask a question Report

DATE FORMATTING IN dd/mm/yyyy [Solved/Closed]

nisha - Sep 3, 2008 at 01:36 AM - Latest reply:  appu
- Jul 23, 2013 at 07:34 AM
Office software Ask a question Report
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.
See more 

13 replies

Best answer
Report Respond to john
john - Mar 17, 2009 at 03:19 AM
38
Thank you
Hi , please use data text to columns to seprate the values and the use the date function to create the format you desire.

Thank you, john 38

Something to say? Add comment

CCM has helped 1813 users this month

Report
Partha - Aug 11, 2009 at 01:41 AM
Hi,
I want to know how shall I change the date in Microsoft SQL server database.
Partha.S.Singha
Report Respond to Balaji
Balaji - Jul 28, 2010 at 09:30 AM
29
Thank you
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
Report
:) - Sep 4, 2010 at 02:28 PM
works the best! thank you
Report
Vishal - Sep 20, 2010 at 07:50 AM
This is great !

thankx a lot. This has saved a lot of time.
Report Respond to NICK
NICK - Feb 6, 2009 at 01:28 PM
17
Thank you
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.
N.
Report
Alison M - Apr 29, 2010 at 05:51 AM
This worked best for me - it seems like a regular issue!
Report
Barbara - Jul 28, 2010 at 12:00 PM
This worked great ! Thank you so much !
Report
appu - Jul 23, 2013 at 07:34 AM
gud solution
Report Respond to Vaishu
Vaishu - Jul 26, 2010 at 02:25 AM
6
Thank you
Use replace all function... Replace all '.' with '-'.
The format will change.
Report Respond to shil
shil - Aug 18, 2010 at 05:41 AM
4
Thank you
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.
Report Respond to rizvisa1
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Aug 18, 2010 at 07:34 AM
1
Thank you
Shil, it is the regional setting. You should type as per regional setting. For display purpose you can change the format of the cell to the way you want it to look
Report Respond to notebookpc
notebookpc 24 Posts Monday August 25, 2008Registration date June 6, 2009 Last seen - Sep 3, 2008 at 05:14 AM
-1
Thank you
if you tell me that you have tried to change the format in excel and nothing happens then there must surely be some problems with your microsoft office and try to uninstall it and then reinstall it it should work fin and I really cant understand why it does want to change the format...
Ask a question