i have huge data on this formate (different date) 13-08-2006. It can't change
of any other formate

ISO standered wrote:
i have huge data on this formate (different date) 13-08-2006. It
can't change of any other formate


And which is the ISO standard format you want to use? It's difficult for us
to help you if you don't tell us...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

ISO date format is yyyy-mm-dd
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Franz Verga" wrote in message
...
ISO standered wrote:
i have huge data on this formate (different date) 13-08-2006. It
can't change of any other formate


And which is the ISO standard format you want to use? It's difficult for
us to help you if you don't tell us...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

If you tried changing the format (Format|Cells|Number tab) and the display
didn't change, then the value in that cell isn't really a date--it's just plain
old text masquerading as a date.

If the "dates" are in a single column, you can convert that column by:

Select the column
Data|Text to columns
delimited (but remove any lines excel guessed and don't add any of your own)
choose dmy as the date type
and finish up that wizard.

Since the values are really dates, you can use format|cells to change the format
to the way you want.

ISO standered wrote:

i have huge data on this formate (different date) 13-08-2006. It can't change
of any other formate

--

Dave Peterson

Sounds like you have imported text rather than a real date.
This formula =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2))
will take a text entry of 13-08-2006 and produce a date value which can then
be formatted to display 2006-08-13
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ISO standered" <ISO wrote in message
...
i have huge data on this formate (different date) 13-08-2006. It can't
change
of any other formate