Jnavar,
Word uses the format you specify. That seems OK to me.
What I should do: make a new column in Excel. Use IF and FORMAT functions, referring to the old column, to show every value the way you like. Then merge this column into word as a simple text field without any formatting (like a name or address).
Hope this helps.
Kees
I used to be able to do Word 97 mail merge easy without this problem from Excel file as source data like this column named NUM below
NUM
47
52.8
75.6
38
24.1
27.8
but with Word 2003
{ MERGEFIELD ''NUM'' }
will not output like
47
52.799999999999997
75.599999999999994
38
24.100000000000001
27.800000000000001
but so I do
{ MERGEFIELD ''NUM'' \# ''0.0''}
it then
47.0
52.7
75.5
38.0
24.1
27.8
How will I output truncating the ''.0'' with Word 2003 mail merge?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic