0
It would appear that the field is actually stored as a number (such as 40030 or 40982) in the file that you're downloading.
If this were a date, then I'd have guessed that it was the number of days from some some reference point such as 1 January 1900.
However, if it's a barrier draw, then perhaps it's encoded into a single number in some way?
If you can find out what the encoding is, then you could use an Excel function (or a C# function if you're downloading via .NET) to transform it into what you want.
Accepted 0
when i export it to excel from google. it dispalys 40982. i then have to select date .short and then it displays as 3/14. when i then go and define it as text it changes to 40982.
0
If you don't want it treating as a date, then you'll need to define it as a text column in Excel.