Format Fields when exporting to excel

[jt8941]

I have a date field which is a string of "Jan 03" when I try to export this to excel it converts it to a date and outputs this in the format of "3-Jan".

Is there a way to control this in cold fusion besides using quotes around it?

 

[FALCONSEYE]

you can use

<Cfoutput>#DateFormat(Now(),"MMM DD, YYYY")#</cfoutput>

http://www.jetansolutions.com

 

[jt8941]

That actually puts it in the format of d-mmm-yy, not the format I specified in the dateFormat? Does excel only allow certain date formats?

 

[FALCONSEYE]

excel must be converting it to a different format automatically.

http://www.jetansolutions.com