Display Text in Excel

Morning All,

I have created a templete etc and all works great when i publish to PDF.

The problem i am getting is when i publish to excel.

My first column contains a string that can either be  000  or  001  etc.

When it goes into PDF is prints it as wanted 000  etc

But when i publish to Excel  it  only puts it to one char  i.e.  0  or  1   etc  not  000  or  001

Any ideas of how i can achieve this.

The code i am using is    :-     <?substring(ACCT,1,3)?>       as i noly need the first three char of the string.

Any help would be appreciated.