Format Field To Text When Downloading Into Excel

[FontanaS]

Hi,

I am downloading a report automatically into excel.
There is one field that is causing me a problem.
It is a text field in the database but some of the values start with a 0 (zero). When it is inserted into excel the 0 (zero) dissapears. I can't find a FormatText function. Is there a function that I can use that will make sure the field is treated as text?

The line of code is -
<td align="left"><font face="Tahoma" size="2"><%=RsRed("ChapterProjectNumber")%></font></td>

THANKS!

 

[Sheco]

It would be an ugly hack but you could print the value so that Excel treats it as a function that returns a text string.

What I mean is, instead of [red][tt]012345[/tt][/red], you would put [red][tt]="012345"[/tt][/red]