export to excel percentage problem

If you format a number in SRS to a percentage using P0 format then export to
excel it left aligns the percentage and reads it as text.
Is there anyway to export to excel and it automatically reads it correctly
as a percentage?I used the formatting code "0.0%" rather than the predefined code and it
exports to Excel correctly.
Colin
"GeoffF" <GeoffF@.discussions.microsoft.com> wrote in message
news:9952F576-F34E-4AE0-B8B8-A499F69B345A@.microsoft.com...
> If you format a number in SRS to a percentage using P0 format then export
> to
> excel it left aligns the percentage and reads it as text.
> Is there anyway to export to excel and it automatically reads it correctly
> as a percentage?

export to excel

Hi:
I have some percentage value in my report. I set these to 0 decimal point
in design layout.
It works fine when display on the web. But when I export them to excel,
these value is set to 1 decimal point.
Is there a way to round to no decimal point when exporting to excel?Ken,
Indeed the standard percentage format without decimals (P0) doesn't export
correctly to Excel. You can use #,##0% as a custom format.
Jan Pieter Posthuma
"ken" wrote:
> Hi:
> I have some percentage value in my report. I set these to 0 decimal point
> in design layout.
> It works fine when display on the web. But when I export them to excel,
> these value is set to 1 decimal point.
> Is there a way to round to no decimal point when exporting to excel?
>|||Thanks Jan, it's very helpful
"Jan Pieter Posthuma" wrote:
> Ken,
> Indeed the standard percentage format without decimals (P0) doesn't export
> correctly to Excel. You can use #,##0% as a custom format.
> Jan Pieter Posthuma
> "ken" wrote:
> > Hi:
> > I have some percentage value in my report. I set these to 0 decimal point
> > in design layout.
> > It works fine when display on the web. But when I export them to excel,
> > these value is set to 1 decimal point.
> > Is there a way to round to no decimal point when exporting to excel?
> >