Convert date (isnumber TRUE) formatted ddd mm/yy/yyyy as text

[LoveExcel2TheMax]

Convert date (isnumber TRUE) formatted ddd mm/yy/yyyy to text.

 

[Peter_SSs]

formatted ddd mm/yy/yyyy

That is an unusual format - are you sure that is the current format, especially the yy/yyyy part?

What format do you want the text result to have?

 

[bebo021999]

Is it are you looking for?

=TEXT(A1,"ddd mm/yy/yyyy")

 

[LoveExcel2TheMax]

That is an unusual format - are you sure that is the current format, especially the yy/yyyy part?

What format do you want the text result to have?

Original post had a typo. I'm looking for a way to convert a date (isnumber TRUE) formatted as ddd mm/dd/yyyy to text.

 

[Fluff]

Did you try the formula from bebo changing the /yy/ to /dd/ ?

 

[LoveExcel2TheMax]

Original post had a typo. Original post should have been: Convert date (isnumber TRUE) formatted ddd mm/dd/yyyy to text.. Thank you, bebo021999, you have solved my problem. I'm good to go now.

 

[Fluff]

@LoveExcel2TheMax in future please do not post links that are irrelevant to the thread. I have removed it this time.

 

[Peter_SSs]

Also, please mark the post that actually contains the solution. I have changed it for you this time.