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 ...
hey calgar1700 it's not working because text formula always extract "text" , so i suggest you to appy =Int(b62) and then use date format
hope this should work
hope this should work
INT() from text returns #VALUE!
- hey thanks for correcting ,
1. replace (.)dot with / or -
and use this formula =text(a62,"dddd")
hope this will workPerhaps 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.
