How to convert Date into text.
Solved/Closed
rk gupta
-
30 Jan 2017 à 08:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Jan 2017 à 11:51
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 30 Jan 2017 à 11:51
Related:
- Excel convert date to text
- Convert date to text excel - Best answers
- Convert date to text in excel - Best answers
- Convert number to words in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Amv convert tool - Download - Video converters
- Excel to pdf converter free download - Download - PDF
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
30 Jan 2017 à 11:51
30 Jan 2017 à 11:51
Hi rk gupta,
Use WordNum (google search the code) for the day and year (use DAY() and YEAR() to isolate those numbers). For the month use this:
=TEXT(A1,"mmmm")
Then string those 3 value together with & and maybe some " " for spacing.
Best regards,
Trowa
Use WordNum (google search the code) for the day and year (use DAY() and YEAR() to isolate those numbers). For the month use this:
=TEXT(A1,"mmmm")
Then string those 3 value together with & and maybe some " " for spacing.
Best regards,
Trowa
