On Tue, 27 May 2008 19:59:01 -0700, Homero
wrote:

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