Percentage format displaying incorrectly

[Leicester City Fox]

Hi there
I have updated a table of percentage, but they are displayingincorrectly Example 95% comes out as 9500% as a percent there are no decimals?
Can any body suggest a format that will convert my percentcorrect format i.e. 95% not 9500.00 I have a table of 100 of these figures?
Thank you
Leicester Fox

 

[steve the fish]

Type 100 in a cell out of the way. Copy that cell. Highlight the cells in the table. Right click. You now need the paste special dialog box so hover over the little arrow then click paste special. Click the divide radio button and ok. Format the cells to percentage.

 

[Leicester City Fox]

Hi Steve

Thank you that worked a treat... Your a Star

Many Thanks

Leicester City Fox