Convert date in A2 to dd-mm-yyyy in C2

[Muthukrishnan V]

Convert date in A2 to dd-mm-yyyy format in C2.xlsx
	A	B	C	D	E	F
1	Date		To convert :		Excel 365
2	2/26/2008		26-02-2008		Request formula to
3					convert A2 to
4					dd-mm-yyyy in C2.
5
6					How to find how A2
7					is formatted as text
8					or date?
Sheet1

 

[Peter_SSs]

Does this work for you? Use the formula shown and format the formula column with the data format you want.

24 04 02.xlsm
	A	B	C
1	Date		To convert :
2	2/26/2008		26-02-2008
Convert Date

Cell Formulas
Range	Formula
C2	C2	=--TEXTJOIN("-",,INDEX(TEXTSPLIT(A2,"/"),{2,1,3}))

 

[shaowu459]

2 for text, 1 for date.

工作簿1
	A	B	C	D	E	F
1	Date		To convert :		Excel 365
2	2/26/2008		2		Request formula to
3	2024-4-2		1		convert A2 to
4					dd-mm-yyyy in C2.
5
6					How to find how A2
7					is formatted as text
8					or date?
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=TYPE(A2)

 

[Alex Blakenburg]

Another way to find whether A2 (or column A) is being recognised by Excel as being text or date:-
• Change the format of column. Pick something that is glaringly obvious ie General (which would show a number for dates)
Anything that changes is a date anything that doesn't is text.
• Then ctrl+z to restore the format.

 

[bobsan42]

To convert date to text:

=TEXT(C2,"dd-mm-yyyy")

Converting date to text loses the date information. If you have a date and you only want to change the way it is displayed use Number formatting:

(for Date or Custom)

One way to distinguish btw text and Date/Number is the Type function, as shown above by shaowu459
Easier and quick: if you have not manually applied any text alignment to cells then: text is shown as left aligned, numbers and dates/times - as right aligned, logical as centered

 

[Muthukrishnan V]

Thank you Mr Peter sir, Works fine

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.

 

[Muthukrishnan V]

I also thank Mr. Shaowu, Mr. Alex Blakenburg and Mr. Bobsan for their valuable guidance to find Cell formatting.
I am grateful to our Forum.