Convert text to date format

February 13, 2012 at 02:39:13
Specs: Windows XP
I have written date 01.02.2012 in a cell and i want to convert this text date to date format 2/1/2012 or 1-Feb-2012..PLZ help me

See More: Convert text to date format

Report •

#1
February 13, 2012 at 08:22:36
Do a Search & Replace.

Search for a DOT
Replace with a SLASH

Should give you a DATE.

MIKE

http://www.skeptic.com/


Report •

#2
February 14, 2012 at 23:29:31
It Should Automatically Change, But Depends On THe Regional Settings Of Your PC too.

Report •

#3
February 17, 2012 at 03:56:23
Its not happening ....I already try this.
I have the date 01.02.2012
I replaced / in the place( .) it converted in 1/2/2012.
And when when i tried to change in another format like 1-may-2011
Its showing Just Opposite 2-Jan-12.
But my actual date should be 1-Feb-2012.

Report •

Related Solutions

#4
February 17, 2012 at 11:17:07
How do you have your Operating System Time set up?

On my U.S. system the default Date Format is: Month / Day / Year
so when I convert 01.02.2012 to 01/02/2012 it means: January 02, 2012

If you want your default Date Format as: Day / Month / Year
you need to change your System Time.

For Windows XP see here:

http://support.microsoft.com/kb/307938

MIKE

http://www.skeptic.com/


Report •

Ask Question