I have a file with dates in one column, trying to change the date format but
the format command does not work. The values do not appear to be stored as
text, but will not change to any other format (general, number, currency,
etc) unless each cell is selected and edited (i.e. double click on the cell
then leave the cell) then the format changes. Too many cells to do this
manually. It only occurs in one column, all others change with the format
command. Tried pasting the values to another pre-formatted cell, no luck.
Anyone know why this happens?