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 |
and customised in cell format as text , custom
wh y wont it work ? i want to display the day in words..
also, the sheet and workbook protect function doesnt seem to work
im using office 365 trial version , 64 bit i think..
thanks
c....
wish to show eg monday Ist october 1999
ie. words format not numbers..
this is the 2 cells again , cell 1 is date form
cell 2 is also date format
08.09.2019 08.09.2019 it keeps showing up as just replica of cell 1
have done istext test and date in cell 1 has form 8.9.2019 date format
... when composing formula i dont knw what to put in text format , line 2......
i have at the moment =TEXT(A62,"DDDD, DD.MMMM YYYY")
my textbook says =text(... is the correct formula...
thanks for reply
c...
- ps im using i assume usa version of excel on a german keyboard set to german input
all data is going in as expected though , and using day moth year format
all in english..Assuming your first cell is A1 you may is here text or not entering =ISTEXT(A1) in any empty cell. If TRUE you have the text, not date.
To check your default date format, use Win+R (assuming your are on Windows), here type control international when Ok and see what is your Short date format. If it's not what you'd like to have on your PC, you may change it here from available options in drop-down list.
Are you sure you have date, not text, in first cell? You may check by ISTEXT()
- 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 workINT() from text returns #VALUE!
- hey thanks for correcting ,
1. replace (.)dot with / or -
and use this formula =text(a62,"dddd")
hope this will work
