I am trying to change the format on all cells in colums A but it wont change.
Trying to change it to "yyyy.mm.dd hh:mm"
Currently is at "yyyy.mm.dd"
So in the end it should show : "2011.08.10 00:00"
Trying formating, Converting to number, clearing the data, etc... nothing would work.
Last edited by tsioumiou; 06-11-2012 at 08:37 AM.
You can't change the format because your 'dates' are text values
use this formula: =A1&" 00:00"
copy down then Copy that new column and Paste Special - Values over the original column and delete the formula column
It doesn't recognize your format as dates, try this formula to convert to date first then change your formats. =CONCATENATE(MID(A1,6,2),"/",RIGHT(A1,2),"/",LEFT(A1,4))
The values in column A are text, not dates. To convert them to dates, you can try this:
Select column A, then click Data > Text to columns > next > next > select the "Date" radio button > select YMD in the drop down > Finish
Now the values are dates and the format you apply will take.
No need for formulas or copy/paste.
Last edited by npamcpp; 06-11-2012 at 08:21 AM.
Like a post? Click the star below it!
Tried only the first one and it worked.
Thanks!
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks