Excel as a database

E

Erin Jenkins

I am using excel as a database for customers. When I try to merge th
database it adds 10 decimal points behind my financial numbers.
would like it to merge exactly as it is in my database. Please help!

By the way, I got it to work on all my fields except my % fields o
fields that I need to show at least 2 decimal points
 
L

Lady Layla

Tools Options Edit Uncheck Fixed Decimal

: I am using excel as a database for customers. When I try to merge the
: database it adds 10 decimal points behind my financial numbers. I
: would like it to merge exactly as it is in my database. Please help!
:
: By the way, I got it to work on all my fields except my % fields or
: fields that I need to show at least 2 decimal points.
:
:
: ---
:
:
 
D

Debra Dalgleish

After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document
 
E

Erin Jenkins

thank you lady layla and Debra

It ended up that I didn't have the option turned on to choose what
format to import the data. After I turned it on and used both of your
suggestions it was quite easy.

Thanks for your help
Erin
 
Top