Date Values

[Sharlene England]

I would like to be able to enter a date as 25.12.2003

and in the next cell over have it formated as December 25, 2003

If there a simple way to do this?

Thanks for any help.

Sharlene England

 

[Debra Dalgleish]

If your regional settings have a short date style of 25/12/2003, you
could enter this formula in the adjacent cell:

=SUBSTITUTE(A2,".","/")+0

Select the cell with the formula
Choose Format>Cells
On the Number tab, select the Custom category
Clear the text box, and type: mmmm d, yyyy
Click OK

 

[Peo Sjoblom]

One possible way

=TEXT(DATE(RIGHT(A1,4),MID(A1,FIND(".",A1)+1,2),LEFT(A1,FIND(".",A1)-1)),"mm
mm dd, yyyy")

 

[Ron Rosenfeld]

I would like to be able to enter a date as 25.12.2003

and in the next cell over have it formated as December 25, 2003

If there a simple way to do this?

Thanks for any help.

Sharlene England

=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))

Format as
mmmm dd, yyyy


--ron