CODEWITHSUNDEEP
exceloffice365
Richard
Richard

Reputation: 23

Excel converts to Time Format

Excel is converting any number it seems to a time format, which of course I don't want. Even if I create a new pivot chart.

For example I have a dataset with about 5 rows, each of which has a student ID. If I create a pivot, I want the new pivot to begin with "count of student ID."

However, I see 01/15/1915 12:00:00. When I convert the sheet to general (or any valid format) I get what I want, which is 5494. When I create the pivot and click on a cell, I should get the data of number of students behind that number. But then the data that comes up also needs to be converted. I have no idea why this is happening. And yes, I have tried reformatting the original data.

I think this is a bug or setting in Excel. Any ideas? Thanks.

Upvotes: 0

Views: 37

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60464

What version of Excel. There was an old bug in 2007 where the Normal style would spontaneously change under ill-defined conditions. Don't know if it has been fixed. If that is the case, navigate to Home --> Styles --> click on the dropdown arrow and right click on Normal --> Modify and see what the number format is. If it is not General, then click on Format and correct it.

enter image description here

Upvotes: 1

Related Questions