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?