Report Builder: output to Excel removes leading zeros

[Guest]

I'm trying to use the Report Builder to output a numeric field to EXCEL , but on numbers that start with zero EXCEL removes the leading zero's. ex. 00123 becomes 123.

Is there something that I can put in the expression builder on the field to overcome this.

I've tried concatonating a single quote on the front of the field but the single quote shows up on the output. I've tried this on both the SQL and on the expression builder.

I've read on some of the posts where people have tried using 'mso-number-format:"\@'" within a TD tag but I can't seem to get the syntax right inside the Expression Builder.

Has anybody got any suggestions?

[Libby]

I'm not familiar with Report Builder - so this might not make sense.

Put   before the item to be output:

<td> #payment_type#</td>

[Cozmo2]

Has anyone found a way to do this yet? Or to format the fields (i.e. 123 should print like 123.00).

[Xuan_Mai]

Excel will remove leading zeros in a numeric field because it is treating the column as numeric. Putting a ' in front of the number forces Excel to treat the column as text.