Dylan has entered a date in a cell and Excel has automatically shortened it, but Dylan wants the cell to display the data as he originally

Question

entered it. How can Dylan fix this problem?
(1 point)
Retype the data into the cell.
Right-click the cell and select Format Cells.
Use Data > Data Types and select “String.”
Enter the correct text directly into the formula bar.

Answer 1

Dylan can fix this problem by selecting the option "Right-click the cell and select Format Cells." This will allow him to change the formatting of the cell to prevent Excel from automatically shortening or altering the date he entered.