State Suggested Answer
+1 person also asked this people also asked this
Replies 10 replies
Answers 1 answer
Subscribers 6 subscribers
Views 6986 views
Users 0 members are here

Date format issue in excel report

akshayan

A Score Level 2

over 5 years ago

We are using "Export SQL to Excel" smart service from "Excel Tools" plugin to create an excel report. Even though we have set a column to date format (column data type is date as well, database is Oracle) in the excel template, the generated excel does not retain the date format. Is there a way to force excel recognize the cell values as date for a column?

Discussion posts and replies are publicly visible