How do I copy a date "03/28/08" in column "A" to paste as text "032808" in column "B"?
J joeb Apr 29, 2008 #1 How do I copy a date "03/28/08" in column "A" to paste as text "032808" in column "B"?
K Kevin B Apr 29, 2008 #2 The following formula will do the trick, just change the cell address to fit your requirements: =TEXT(A1,"mmddyy") The function converts whatever number is in A1 and then formats the number according to the format mask argument.
The following formula will do the trick, just change the cell address to fit your requirements: =TEXT(A1,"mmddyy") The function converts whatever number is in A1 and then formats the number according to the format mask argument.
