Forum Discussion
date conversion
trying to alter date in date format to calendar / time or text format ie. nos. to words this is the area below : the formula i used is =TEXT(A62,"dddd") in 2nd cell 01.10.99 01.10.99 ...
INT() from text returns #VALUE!
hey thanks for correcting ,
1. replace (.)dot with / or -
and use this formula =text(a62,"dddd")
hope this will work
1. replace (.)dot with / or -
and use this formula =text(a62,"dddd")
hope this will work
Perhaps you assume there is the date in A62. I guess it is a text representation of the date here. TEXT() on text returns exactly the same text.
- further more about your query of long date
suggest you to use / or - intead of (.) dot then use this
=text(a62,"dddd,dd/mmmm/yyyy)