how do convert these dates from text to numbers
i tried the previous method, but i failed.
thanks all
how do convert these dates from text to numbers
i tried the previous method, but i failed.
thanks all
Enter formula in A1 and copy down
Formula:Please Login or Register to view this content.
Or this
Formula:Please Login or Register to view this content.
v A B 1 6/1/2017 Thu, 1 Jun 2 6/2/2017 Fri 2 Jun 3 6/3/2017 Sat 3 Jun 4 6/4/2017 Sun 4 Jun 5 6/5/2017 Mon 5 Jun 6 6/6/2017 Tue 6 Jun 7 6/7/2017 Wed 7 Jun 8 6/8/2017 Thu 8 Jun 9 6/9/2017 Fri 9 Jun 10 6/10/2017 Sat 10 Jun 11 6/11/2017 Sun 11 Jun 12 6/12/2017 Mon 12 Jun 13 6/13/2017 Tue 13 Jun 14 6/14/2017 Wed 14 Jun 15 6/15/2017 Thu 15 Jun 16 6/16/2017 Fri 16 Jun 17 6/17/2017 Sat 17 Jun 18 6/18/2017 Sun 18 Jun 19 6/19/2017 Mon 19 Jun 20 6/20/2017 Tue 20 Jun 21 6/21/2017 Wed 21 Jun 22 6/22/2017 Thu 22 Jun 23 6/23/2017 Fri 23 Jun 24 6/24/2017 Sat 24 Jun 25 6/25/2017 Sun 25 Jun 26 6/26/2017 Mon 26 Jun
Last edited by AlKey; 06-20-2018 at 10:25 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks AlKey very much for your kind and speedy help
You can also do. Go to the Home tab then go to Number category. Click on the drop down menu and chose Text to convert to number.
Best regards,
MLV
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks