Formatting Dates

[Homero]

Excel Cant read dates separated with point (not even using formatting in
Armenian)
example: DD.MM.YYYY

how could I convert that format into DD-MM-YYYY, I have tried almost every
resurce I noew, but no results

Thanx

 

[ASA]

If date is always in that format then =DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))

 

[ASA]

=DATEVALUE(SUBSTITUTE(A1,".","/")) and format your cell as a date

 

[Arvi Laanemets]

Hi

Select the range with dates and format as date or general;
Replace all "." with "-" (use ReplaceAll feature)

 

[Dave Curtis]

Hi,

Try entering the following formula.

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

and apply a custom format to the cell of dd-mm-yyyy

It works by extracting the digits for the year, month and date.

Dave

url:http://www.ureader.com/msg/104234314.aspx

 

[Dave Curtis]

Hi,

Just thought of another way.
Use the following formula

=DATEVALUE(SUBSTITUTE(A1,".","/"))

and apply a custom format of dd-mm-yyyy

Dave

url:http://www.ureader.com/msg/104234314.aspx

 

[Ron Rosenfeld]

Excel Cant read dates separated with point (not even using formatting in
Armenian)
example: DD.MM.YYYY

how could I convert that format into DD-MM-YYYY, I have tried almost every
resurce I noew, but no results

Thanx

Assuming your dates are in a column:

Select the dates
Select Data/Text-to-Columns
<NEXT>
<NEXT>
At step 3, select Date, and then DMY from the dropdown box.
<FINISH>

--ron