Forum Discussion

Copper Contributor

Aug 08, 2019

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 ...

Bronze Contributor

Aug 08, 2019

Hello calgar1700,

What exactly would you like to display in the second cell?

Copper Contributor

Aug 09, 2019

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..

SergeiBaklan
Diamond Contributor
Aug 09, 2019
calgar1700

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.
- calgar1700
  Copper Contributor
  Aug 10, 2019
  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 !
  - PReagan
    Bronze Contributor
    Aug 11, 2019
    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

Resources