Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: In the format cells dialog box you can format all of the following except: (Points : 3) Font Fill Protection Tab name
A: E-mail this page Print this page Share with Messenger Share on Facebook Share on Twitter Article ID: 264372 - Last Review: September 18, [ 2011 - Revision: 7.0 How to control and understand settings in the Format Cells dialog box in Excel View products that this article applies to. This article was previously published under Q264372 For a Microsoft Excel for Macintosh version of this article,
see 298368 . On This Page Expand all | Collapse all SUMMARY Microsoft Excel lets you change many of the ways it displays data in a cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a pattern and border to the cell. You can access and modify the majority of these settings in the Format Cells dialog box (on the Format menu, click Cells). The "More Information" section of this article provides information about each of the settings available in the Format Cells dialog box and how each of these settings can affect the way your data is presented. Back to the top MORE INFORMATION There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The following sections describe the settings available in each tab. Back to the top Number Tab Auto Number Formatting By default, all worksheet cells are formatted with the General number format. With the General format, anything you type into the cell is usually left as-is. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526. This is because the cell remains in the General number format. However, if you first format the cell as a date (for example, d/d/yyyy) and then type the number 36526, the cell displays 1/1/2000. There are also other situations where Excel leaves the number format as General, but the cell contents are not displayed exactly as they were typed. For example, if you have a narrow column and you type a long string of digits like 123456789, the cell might instead display something like 1.2E+08. ]
Get an answer
Original conversation
User: In the format cells dialog box you can format all of the following except:

User: In the format cells dialog box you can format all of the following except: (Points : 3) Font Fill Protection Tab name





Weegy: E-mail this page Print this page Share with Messenger Share on Facebook Share on Twitter Article ID: 264372 - Last Review: September 18, [ 2011 - Revision: 7.0 How to control and understand settings in the Format Cells dialog box in Excel View products that this article applies to. This article was previously published under Q264372 For a Microsoft Excel for Macintosh version of this article, see 298368 . On This Page Expand all | Collapse all SUMMARY Microsoft Excel lets you change many of the ways it displays data in a cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a pattern and border to the cell. You can access and modify the majority of these settings in the Format Cells dialog box (on the Format menu, click Cells). The "More Information" section of this article provides information about each of the settings available in the Format Cells dialog box and how each of these settings can affect the way your data is presented. Back to the top MORE INFORMATION There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The following sections describe the settings available in each tab. Back to the top Number Tab Auto Number Formatting By default, all worksheet cells are formatted with the General number format. With the General format, anything you type into the cell is usually left as-is. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526. This is because the cell remains in the General number format. However, if you first format the cell as a date (for example, d/d/yyyy) and then type the number 36526, the cell displays 1/1/2000. There are also other situations where Excel leaves the number format as General, but the cell contents are not displayed exactly as they were typed. For example, if you have a narrow column and you type a long string of digits like 123456789, the cell might instead display something like 1.2E+08. ]



Question
Asked 1/14/2012 5:17:18 PM
0 Answers/Comments
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
27,008,087 questions answered
*
Get answers from Weegy and a team of really smart lives experts.
S
L
Points 247 [Total 265] Ratings 0 Comments 177 Invitations 7 Offline
S
L
Points 130 [Total 130] Ratings 0 Comments 130 Invitations 0 Offline
S
L
R
Points 125 [Total 276] Ratings 1 Comments 5 Invitations 11 Offline
S
R
L
R
P
R
P
R
Points 66 [Total 734] Ratings 0 Comments 6 Invitations 6 Offline
S
1
L
L
P
R
P
L
P
P
R
P
R
P
R
P
P
Points 62 [Total 13329] Ratings 0 Comments 62 Invitations 0 Offline
S
L
1
R
Points 34 [Total 1450] Ratings 2 Comments 14 Invitations 0 Offline
S
L
Points 10 [Total 187] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 10 [Total 13] Ratings 0 Comments 10 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.