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
karthik.net87 0 Newbie Poster
urtrivedi 276 Nearly a Posting Virtuoso
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.
karthik.net87 0 Newbie Poster
Ya i tried it but it shows in excel again 28:30:00 and is there any other solution
urtrivedi 276 Nearly a Posting Virtuoso
in your grid view if there is data type property then change it to varchar
karthik.net87 0 Newbie Poster
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.