yogi_Rearrange Data in Columns A to C In DataBase Style So That Each Selected Option Is Presented In A Separate Row of Its Own - 2

                      Google Spreadsheet   Post  #1751
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-04-2014
post by JohnKenneth:
(https://productforums.google.com/forum/#!mydiscussions/docs/atK7iOMXdNA)
Hi Yogi.

Sure no problem, here's the link to the test spreadsheet:

https://docs.google.com/spreadsheets/d/1sHL4lhOI_N8QGUOP1L2k-6yCKfWTjq_uxDoNZ0_Oo4Y/edit?usp=sharing

I need column D to be date-formatted, i.e like column A (which the formula in D1 is referencing).

At the moment column D is number-formatted.

I have applied the correct formatting to relevant cells in column D, using the '123' icon. However it doesn't apply the correct/desired format to these cells and remains number-formatted no matter what format is selected.

Let me know if you need any other info from me.

Thanks for your time to date, much appreciated, look forward to your response.

JohnKenneth

-----------------------------------------------------------------------------------------------------------------------------------------

entries shown in JohnKenneth's sheet1 column D are Text entries -- I could not format those as date and Time using 123 dropDowm or via the Format > Number command -- so I had to use the TEXT() function to accomplish the task