Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating
Resolved · Low Priority · Version 2003
Anita has attended:
Excel Intermediate course
how do you get persentages formated from work sheet to work sheet
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
|
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
We'll call during UK business hours
Server loaded in 0.14 secs.