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
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
Just select them, qand goto Format>Cells>Custom and enter that format
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Sounds like they aren't real dates.
Select the colum, goto Data>Text To Columns, select Delimited, then Finish.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks for help
Don't forget to mark the thread as solved using the Thread Tools dropdown.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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?Originally Posted by rangudu_2008
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber