Microsoft Office Forums


Reply
Thread Tools Display Modes

convert to date format

 
 
Mosaddeq Aziz
Guest
Posts: n/a

 
      11-27-2008, 05:44 PM
hi all,

i have exported an word table to excel. in one column of the word file date
was written in the form of dd.mm.yy. now when i copied the the table into
excel, the excel can't read the date in dd.mm.yy. i need excel to convert
them them to dd/mm/yy format and treat them as date. is that possible?

mosaddeq

 
Reply With Quote
 
 
 
 
google@magneticnorth.ca
Guest
Posts: n/a

 
      11-27-2008, 06:09 PM
After the import, select the column of dates and then a simple CTRL+H,
Replace All to replace "." with "/". That should convert the dates on-
the-fly.
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a

 
      11-28-2008, 02:18 AM
I'd check this after the conversion.

I use mdy order and I'm not sure if dates like 01.02.03 would be converted into
the correct date. In fact, 23.12.03 was converted to 23/12/03 -- but it was
that string, not a date.

If the OP's windows short date is dmy order, then I bet it would work ok.

(E-Mail Removed) wrote:
>
> After the import, select the column of dates and then a simple CTRL+H,
> Replace All to replace "." with "/". That should convert the dates on-
> the-fly.


--

Dave Peterson
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a

 
      11-28-2008, 02:20 AM
I'd select the column
Data|text to columns (in xl2003 menus)
then fixed width (and remove any lines that excel may have guessed).

Then choose date (dmy order) and finish up the wizard.

Then format the way you like.

I'd use an unambiguous format first to check, then the dd/mm/yy that you want.

Mosaddeq Aziz wrote:
>
> hi all,
>
> i have exported an word table to excel. in one column of the word file date
> was written in the form of dd.mm.yy. now when i copied the the table into
> excel, the excel can't read the date in dd.mm.yy. i need excel to convert
> them them to dd/mm/yy format and treat them as date. is that possible?
>
> mosaddeq


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
convert date from string to date format Howard - JC Publishing Excel Newsgroup 3 04-09-2008 07:20 PM
Excel date format convert to string format man Excel Newsgroup 1 08-17-2006 09:00 AM
Convert Julian (Date) to Short Date Format SKB Access Newsgroup 2 09-20-2005 03:55 PM
Convert text to date format K McGee Access Newsgroup 1 01-20-2004 04:37 PM
How to convert Excel serial date into Access date format? RADO Access Newsgroup 2 12-27-2003 11:14 AM



All times are GMT. The time now is 02:14 PM.