Excel

R

Renetta

I have a file received via Excel with dates formated as 19840719 I would like
it to reflect as 07191984. is there a way to write a formula to change and
or change?
 
D

Dave Peterson

If the those dates are in a single column, it would be quicker to:

Select that column
Data|Text to columns
Fixed width
remove any lines that excel guesses
choose date (ymd)
and plop it back where it came from.

Then format those cells as mmddyyyy
(format|cells|Number tab|Custom category)
 
G

Gord Dibben

Assuming text is in column A

In B1 enter =MID(A1,5,2)&RIGHT(A1,2)&LEFT(A1,4)

Copy down.


Gord Dibben MS Excel MVP
 
Top