Anita has attended:
Excel Intermediate course
Formating
how do you get persentages formated from work sheet to work sheet
RE: formating
Hi Anita,
Thank you for your post and welcome to the forum, I am going to answer your question in the easiest way possible and then if I have not grasped your question properly perhaps you can come back and we can go into it in more depth.
1. To apply a percentage format to a cell, click the % symbol on the Formatting toolbar while you are in the cell or have a range of cells selected. If this cell is then copied to another location or to another worksheet it will be in % format.
2. Another thought: If you wish to apply % format to more than one worksheet at the same time you could group the Worksheets together and then select the cell or range of cells and follow 1. Above.
3. Another way to apply % format is to use the Menu commands; Format>Cells, Number Tab and click the Percentage Option, here you can set the number of decimal points you wish to apply.
I hope that has helped. Regards Pete