I have a numeric format issue export gridview to excel

My issue is in gridview the time format display 28:30 but when it export to excel it shows 28:30:00 and i need the raw data i.e(28:30)

Help me

Recommended Answers

All 4 Replies

if you have written sql query somewhere than format date or time to text, so when you datatype is text it will not append anything like :00.

Ya i tried it but it shows in excel again 28:30:00 and is there any other solution

in your grid view if there is data type property then change it to varchar

All other data types are varchar only but still i coudnt get

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.