Percentage Formatting

[Doogs2009]

Hi
I am using Excel 2007, Windows XP.

Can someone please tell me how to force percentages to stay formatted as zero decimal places, for eg, 96%.
I have tried and tried everything i know to format the column of data where the percentages are, but they keep coming up as formatted as

<TABLE style="WIDTH: 53pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=71><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 53pt; HEIGHT: 13.5pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl70 height=18 width=71 align=right>9600%</TD></TR></TBODY></TABLE>

What can I do to preserve the formatting as I want it.
Thanks
Craig

 

[Doogs2009]

Re: Percentage Formatting - Update

I finally got something to work for this problem.

Went back to my source data, and i discovered that some of the data was formatted as "Percentage 0 decimal places", and some of it was formatted as the "custom 0[$%-c9)". It wasn't uniform formatting, so I realised that no matter what your desired outcome is, and no matter how many ways you try and fix it, unless the source data has uniform formatting or conditions, this will corrupt any other spreadsheet entries that rely on that source data.
I formatted all the source data to the Percentage 0 Decimal Places format, then changed the result formula to just the

=ROUND(VLOOKUP($A4,Summary!$A$5:$E$30,5,),2)

Then I reset the formats in the result so they lined up with the source data.

Then bingo, i got the result I wanted with the correct formatting at zero decimal places.
Just thought I should share this.
Sincerely Craig

 

[pedro-egoli]

Good to hear. I think the examples I showed indicate that formula's need to be the same too otherwise strange things happen.

Pedro