Conversion from text to date
Closed
JM
-
Dec 8, 2009 at 02:09 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 8, 2009 at 06:06 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 8, 2009 at 06:06 AM
Related:
- Newziea.com
- Unit conversion excel sheet free download - Download - Spreadsheets
- How to pin conversation in messenger - Guide
- Mouse conversion - Download - Mouse and keyboard
- Dos to unix file conversion - Guide
- Newziea.com/block-conversations-from-notifications/ - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 8, 2009 at 06:06 AM
Dec 8, 2009 at 06:06 AM
suppose a1 has the entry
14/02/2011
in B1 copy this formula
you will get
14-February-2011
I still am t rying to find out what that number 29 is doing here. any how this works.
14/02/2011
in B1 copy this formula
=LEFT(A1,2)&"-"&TEXT(MID(A1,4,2)*29,"mmmm")&"-"&RIGHT(A1,4)
you will get
14-February-2011
I still am t rying to find out what that number 29 is doing here. any how this works.
