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)

 

[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