Two Queries:
I have a column with dates like this 2/18/2005 but i want the actual cell text to be 18/2/2005, not just what is displayed.
My main query is....
I have a column(A) of dates (see below) that i want to insert rows with the missing dates so that i have all the dates in the sequence even though there will be multiple rows of some dates i need to have a complete date list.
18-Feb-05
18-Feb-05
23-Feb-05
23-Feb-05
23-Feb-05
23-Feb-05
25-Feb-05
25-Feb-05
25-Feb-05
1-Mar-05
2-Mar-05
2-Mar-05
2-Mar-05
2-Mar-05
4-Mar-05
4-Mar-05
4-Mar-05
Thanks
I have a column with dates like this 2/18/2005 but i want the actual cell text to be 18/2/2005, not just what is displayed.
My main query is....
I have a column(A) of dates (see below) that i want to insert rows with the missing dates so that i have all the dates in the sequence even though there will be multiple rows of some dates i need to have a complete date list.
18-Feb-05
18-Feb-05
23-Feb-05
23-Feb-05
23-Feb-05
23-Feb-05
25-Feb-05
25-Feb-05
25-Feb-05
1-Mar-05
2-Mar-05
2-Mar-05
2-Mar-05
2-Mar-05
4-Mar-05
4-Mar-05
4-Mar-05
Thanks