Microsoft Office Tutorials and References

In Depth Information

**Scientific**

Scientific

Scientific (or exponential) format displays large numbers in a shorthand form—a value,

followed by the letter E, a plus or minus sign, and another number. To convert that format to

its decimal equivalent, move the decimal point by the number of places that appears after

the E—if the value begins with a plus sign, move the decimal point to the right, adding

zeroes if necessary; if there’s a minus sign, move the decimal point to the left, again adding

zeroes as needed. Here are some examples:

●
6.42E+06 is 6,420,000.

●
7.22E-05 is .0000722.

You can enter a number and apply the Scientific format with two decimal places as part of a

single action. Just insert the letter E at the appropriate place.

Numbers expressed using the default settings for the Scientific format are rounded for

display purposes to a maximum of six significant digits, regardless of the cell’s width. To

display numbers using more digits of precision, open the Format Cells dialog box, click

Scientific in the Category list, and increase the number of decimal places (this value must be

between 0 and 30).

Text

When is a number not a number? When you specifically want it to be treated as text. That

happens with part numbers and product identifiers, for example, which can contain leading

zeroes and aren’t typically used in calculations. If you enter a number in a cell, Excel drops

the leading zero and aligns it to the right. To display the cell contents exactly as entered

(including leading zeroes), you must use the Text format, which is available at the bottom

of the Number Format list in the Number group on the Home tab. This category in the

Format Cells dialog box has no additional options.

You can apply the Text format automatically by entering an apostrophe before typing the

number. The apostrophe is stored with the cell entry but is not displayed. Excel formats the

number as text.