Aug 08 2019 04:29 AM
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....
Aug 08 2019 08:29 AM
Aug 08 2019 01:49 PM
Are you sure you have date, not text, in first cell? You may check by ISTEXT()
Aug 09 2019 12:39 AM - edited Aug 09 2019 01:18 AM
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...
Aug 09 2019 01:22 AM
Aug 09 2019 02:19 AM
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.
Aug 10 2019 02:25 PM
i have date format in cell 1 and cell 2
it still wont work.....
what format is there supposed to be in each ?
even if i change date form in cell 1 to a different construct , eg 01.01.19 it wont work ! i mean the form in cell 1 doesnt even change.
now on day 3 of this !
Aug 10 2019 04:14 PM
Could you please attach sample file with values in these two cells, it'll be much easier to discuss.
Aug 10 2019 05:53 PM - edited Aug 10 2019 05:55 PM
Hello @calgar1700,
Assuming your date is in the format dd.mm.yyyy and is located in cell A1, you may use this formula:
=DATEVALUE(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))
Then use the date format "14 March 2012".
Hope this helps!
PReagan
Aug 11 2019 05:19 AM
Aug 11 2019 06:03 AM
Aug 11 2019 06:08 AM
Aug 12 2019 01:41 PM
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.