The approach for (3) was originally created by macropod - you can find his tutorial on "Word Field Maths" here (you may need to sign up to get it). Word will execute a query every time you want to format a number. You then use the Jet SQL format() function to format each number. If you want to distribute your solution, that can be difficult. mdb and put it somewhere where Word can open it. It means you have to create an external Access/Jet. It's actually only really suited to formatting values outside a table, because the DATABASE field cannot be used inside a Word table. Also, the methods described here aren't going to deal properly with variable precision. So if you need to do that, I think you will have to use one cell for the real intermediate result, and another for the display. But when you now reference that cell in another calculation, its value will be 1230, not 1234.5678. Then you have to put a calculation in the cell that will result in 1.23E+3. For example, suppose a cell calculates an intermediate result of 1234.5678 that you want to display, and you are displaying results to 2DP. However, the biggest problem is that unlike Excel, Word does not make a distinction between the value of the cell and the formatted value of the cell. (3) is clunky, but I think it can be done. (2) means that you lose the benefit of what Word's field codes do. (1) is probably your best bet, especially if the calculations are complex, because Word table formulas are really limited compared to Excel's
0 kommentar(er)
