Can I change a date with no format (20051111) to date format?

P

Peo Sjoblom

As long as you have 2 digits for months and days,
select the column, do data>text 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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting templates 7
Table of content - format does not get saved 2
Countdown macro - display settings 2
Date Maniplation 1
Conditional Formatting question.... 1
Address Format changed after Migration 0
Excel Date Formatting 0
Date Formats 4

Top