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

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

"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

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

"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

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Homero" wrote in message
...
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

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

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

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