Page 103 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 89

WORKING WITH EXTERNAL DATA 5

When you import files containing numeric values, uses different separator values, you must make that
be mindful of the characters that represent the distinction before importing data so that Excel can
decimal and thousands separator. By default, properly interpret the numbers.
Excel uses the Regional and Language Options in
the Control Panel of your computer to determine To select the separators, click the Advanced button
how to interpret numbers. For example, in the on the last page of the Text Import Wizard. This
United States, the default number format uses a displays the Advanced Text Import Settings dialog
comma as a thousands separator and a period as box. Select the separator that the data file uses for
a decimal separator. So Excel interprets the both the Decimal Separator and the Thousand
number $1,300.45 as one thousand three hundred Separator. As Excel imports the file, it converts the
dollars and forty-five cents. numbers to match the separators specified on your
computer.
When you import a file containing numbers,
make sure you use the same separators as those
set up on your computer. If the imported file

=$A$1

■ The Import Data dialog ™ Click OK. ■ Excel imports the data
box displays. using the column break
information specified.
¡ Click an option to
designate where you want
your data.

89