data have as a 13-08-2006 i want to change as ISO standered

I

ISO standered

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

Franz Verga

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


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
 
D

Dave Peterson

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.
 
B

Bernard Liengme

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
 
Top