CODEWITHSUNDEEP
fileexcelcsv
Poothabalan S
Poothabalan S

Reputation: 1

Opening a CSV file which has date time field, getting opened in excel with "######"

While opening a CSV file in excel which has datetime field, it is getting opened in excel with the field marked as "######". Is there a way to format the excel file while opening the CSV file???

Upvotes: 0

Views: 140

Answers (1)

Naveed
Naveed

Reputation: 42093

##### - Sometimes referred to as “Railroad tracks”, this error can be caused by several conditions:

  • A number in a cell is too wide for the cell to display it.

  • The formula in the cell produces a result that is too wide for the cell.

  • There is a negative number in the cell that has been formatted for dates or times. Dates and times in Excel must be positive values.

Upvotes: 2

Related Questions