Forum Discussion
date conversion
- 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.
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 !
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...
