Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rose
 
Posts: n/a
Default Can I change a date with no format (20051111) to date format?

Can I change a date with no format ex: 20051111 to a date format ex:
11/11/2005?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Can I change a date with no format (20051111) to date format?

As long as you have 2 digits for months and days,
select the column, do datatext to columns, click next twice,
under column data format select date and then select YMD
assuming that is the order of the original. Then it will retrun a date based
on your regional setting so if in US you should get MDY

--

Regards,

Peo Sjoblom

"Rose" wrote in message
...
Can I change a date with no format ex: 20051111 to a date format ex:
11/11/2005?



  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default Can I change a date with no format (20051111) to date format?

Alternatively use =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
If needed you could insert a column for this, then use Copy followed by
Paste Special-Values to convert formulas to dates; now delete the original
column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rose" wrote in message
...
Can I change a date with no format ex: 20051111 to a date format ex:
11/11/2005?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
I cannot change the date format to English canada DStanfield Excel Discussion (Misc queries) 2 September 28th 05 06:23 PM
How change Excel default date format to something useful mjk Excel Discussion (Misc queries) 1 September 26th 05 08:15 PM
how do I format cells to change date and time to just date bondam Excel Discussion (Misc queries) 3 July 3rd 05 01:10 PM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 10:45 PM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"