PDA

View Full Version : Solved: Cells format



szczepan
04-30-2008, 06:14 AM
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
04-30-2008, 06:31 AM
Just select them, qand goto Format>Cells>Custom and enter that format

szczepan
04-30-2008, 07:38 AM
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
04-30-2008, 08:14 AM
Sounds like they aren't real dates.

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

szczepan
05-05-2008, 02:16 AM
Thanks for help

mdmackillop
05-05-2008, 04:14 AM
Don't forget to mark the thread as solved using the Thread Tools dropdown.

rangudu_2008
05-05-2008, 08:22 AM
You can select the column, then go to Data > Text To Columns option, then select Delimited, then Finish.

Bob Phillips
05-05-2008, 10:39 AM
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?