Search : in
By :

DATE FORMATTING IN dd/mm/yyyy

Last answer on Aug 11, 2009 6:41:07 am BST nisha, on Sep 3, 2008 6:36:24 am BST 
 Report this message to moderators

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.

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « DATE FORMATTING IN dd/mm/yyyy » in :
Verifying date format in PHP Show Verifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Batch Script - Move files to \%date%\%time%\ ShowBatch Script - Move files to \%date%\%time%\ Issue Solution Note Issue I have been trying to make a simple batch script to create database backups and move then into a folder named by date, and a sub folder by time. This is what I...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Download Winmail Opener ShowWinmail Opener is a small very simple utility allowing to read contents of TNEF-encoded e-mail (winmail.dat ). If you receive an E-mail with winmail.dat format, Winmail Opener will allow you to read the contents. Winmail Opener possesses the...
Formatting - Formatting a hard drive ShowBefore trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even...
S/PDIF format ShowS/PDIF format The S/PDIF standard ("Sony/Philips Digital Interface", or SPDIF for short) is a digital audio data transfer format. It is an international standard known as "IEC-958 type II", which defines both hardware specifications (physical...

1

notebookpc, on Sep 3, 2008 10:14:49 am BST
  • +4

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...

Reply to notebookpc

2

NICK, on Feb 6, 2009 6:28:37 pm GMT
  • +2

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.

Reply to NICK

3

john, on Mar 17, 2009 7:19:25 am GMT
  • +6

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

Reply to john

4

 Partha, on Aug 11, 2009 6:41:07 am BST

Hi,
I want to know how shall I change the date in Microsoft SQL server database.
Partha.S.Singha

Reply to Partha