Try this -
Select the column
Choose Data-Text to column
Click FINISH

"ssignore" wrote:

Hello, MS Online Community.
I have a column of dates in a spreadsheet where the date is in the following
format:
"M/D/YYYY"
If I look at Format-Cell, I see the Date category highlighted with the
MM/DD/YY format type selected, however, the dates in the column will not
respond to this format.
I did notice that if I double-clicked inside the cell (for the Edit mode)
and then clicked elsewhere on the spreadsheet, it would convert to the
MM/DD/YY format.
There must be a way in which to switch to the Edit mode for an entire column
instead of double-clicking individually.
Any ideas?
Thanks!
ssignore