hi
I have a table column I has format tues 12/04/2014 ect,when I filter to put date in order it seems to use day first and messes the dates up how can I remove day ,tues ect into another column,i get table sent to me so can not tell them to do at source,any ideas please
cheers colin
Last edited by cfinch100; 04-17-2014 at 09:14 AM.
The code removes the days from column I. It does not copy them in to another column.
Last edited by AB33; 04-16-2014 at 03:13 PM.
hi
wow im in awe ,works like a charm not the sort of code I was trying,many thanks
colin
I have just amended it to copy the days in to separate column.
Try the above attached.
hi
excellent many thanks you must have read my mind
cheers colin
hi
I have added split day ,and changed the column from I to h but will not split day and date now any ideas please , obviously ive done some thing wrong,on first post its called split day
cheers colin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks