Solved: Cells format

[szczepan]

Hi,

I need a quick help. I need to change format of selected cells. At that moment cells have text format dd-mm-yy hh-mm-ss and I need to convert them to date format dd-mmm-yyyy.

Thanks in advance

szczepan

[Bob Phillips]

Just select them, qand goto Format>Cells>Custom and enter that format

[szczepan]

This combination I now. but when I do this of format of cell/cells changes but dates in the cell are still the same ex. 30-04-08 12:53:22

[Bob Phillips]

Sounds like they aren't real dates.

Select the colum, goto Data>Text To Columns, select Delimited, then Finish.

[szczepan]

Thanks for help

[mdmackillop]

Don't forget to mark the thread as solved using the Thread Tools dropdown.

[rangudu_2008]

You can select the column, then go to Data > Text To Columns option, then select Delimited, then Finish.

[Bob Phillips]

You can select the column, then go to Data > Text To Columns option, then select Delimited, then Finish.

Do you mean in the way that I told him over a day ago?