Word document problem formatting
I have converted a Filemaker table to Excel to merge into a Word document (a 16 page contract with many merge fields). It all works well except that numbers are showing with umpteen decimal places despite the fact that the fields are formatted to 2 decimal places in the original Filemaker table. When converting to Excel I am ticking the box saying "apply current layout's formatting to exported data". In the newly created Excel document the number cells show as only 2 decimal places, but in the data entry panel sho with many decimal places. The Word document on merging shows all the decimal places.
Any ideas on how to solve this without manually going through every number cell and re-entering it to 2 places?
Any help would be much appreciated.