Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
formating

ResolvedVersion 2003

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

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.