Forum Discussion
Excel cells formatted as date, but still showing numeric value
Doing an assignment for a class where we were transposing data. The rows for the date in the original data were formatted as date, and shows up fine. However, when I transpose the data, it shows up a...
It's a little difficult to diagnose from afar without seeing the actual.
My first thought--my hypothesis--is that it's possible that in the transposing the new values were pasted as text.
Appearing as numbers but actually text. In that case, it wouldn't really change them if you formatted the cells as dates.....the contents of the cell, if they're actually text, are no longer subject to the various numeric formats.