List Dates in Column A1
Closed
lt_ac_woods
Posts
1
Registration date
Monday October 7, 2013
Status
Member
Last seen
October 7, 2013
-
Oct 7, 2013 at 08:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 7, 2013 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 7, 2013 at 11:49 AM
Related:
- List Dates in Column A1
- My contacts list names - Guide
- Whatsapp country code list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Counter strike 1.6 cheats list - Guide
- Display two columns in data validation list but return only one - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 7, 2013 at 11:49 AM
Oct 7, 2013 at 11:49 AM
Hi It_ac_woods,
Try this:
A1: 41579
A2: 41579.25
Drag these two cells down as far as desired and change format to date.
This basically adds time to the date.
If you don't want that because of further calculations use another (temporary) column and use the INT formula as in:
=INT(A1)
Best regards,
Trowa
Try this:
A1: 41579
A2: 41579.25
Drag these two cells down as far as desired and change format to date.
This basically adds time to the date.
If you don't want that because of further calculations use another (temporary) column and use the INT formula as in:
=INT(A1)
Best regards,
Trowa
