Decimals (XP)

Topic

New Reply

I have a source database in Excel that includes student’s GPA scores – which have to be at least 2 decimal places. I’m importing all of this data into Word as labels – can’t seem to get ONLY the 2 decimal places on the labels – get more than 5.

Fix?

Reply | Quote

Replies

Are you using mail merge? If so, you have two options in Word:

One option is to add a format switch to the merge fields:
– Right-click a merge field.
– Select Toggle Field Codes from the popup menu.
– Insert the following before the closing brace } but after the merge field name.

# "0.00"

– Press F9 to hide the field code and to update the field.

Another method:
– In Word, select Tools | Options…
– Activate the General tab.
– Tick the “Confirm conversion at Open” check box.
– Click OK.
– Go back to step 3 of the mail merge wizard (task pane).
– Click “Select a different list”.
– Locate your workbook again.
– This time, you’ll be prompted for a method to connect to the workbook.
– Select “MS Excel worksheets via DDE (*.xls)”, then click OK.
– Continue as usual.
The merge should now preserve the number formatting from Excel.

Reply | Quote

Thanks – I had no clue you could do that in Word – BUT

turns out just using the “fixed” function in Excel to change the numbers to text worked just fine . . . sooooooooooooo

Thanks again for your help

Aunt linda

Reply | Quote