crazyfray

Had no real time for reading for pleasure recently (more's the pity). Last book I remember reading was The Cold Moon by Jeffrey Deaver (I think that's what it's called). I'm waiting on the translation of Spiral by Koji Suzuki (The Ring films were based on his books, and Spiral is the third in the trilogy of Ring, Loop and Spiral) - really superb books. (slightly off-topic, but the American films were nowhere near as good as the Japanese ones...though Ring 0 is plain weird) Mainly been reading computing texts recently: Flash in 24hrs (since my basics weren't up to scratch ), Brilliant Photoshop CS...oh, and Database Design for Mere Mortals (best title ever ).

First off, what version of Office are you using? About the process: 1 - You doing this programatically, or manually? (as in, do you use the letters and mailings bit, and give the options each time, or are you using VBA/VB whatever?) 2 - How are you performing the rounding? using =round(VALUE, 2) , or a format (as in right-click on cell location, format cells, number)? 3 - Have you tried converting the values to text first? That often works well...use =text(VALUE) 4 - You mentioned that the value number of years is then a decimal...if you look at the number format, is it a decimal, a year, or a custom format? Basically, it comes down to the fact that Word doesn't really understand formats (or so it seems), so it's best to handle the formatting from Excel (unless this is a stage in some kind of convoluted process where you're going to be using the Word document as raw data!) Can you upload a copy of the source file, or at least give someidea of how the data has been calculated? Hope you manage to get it sorted out...will have a glance back here during the week(or possibly today ). BTW - My answers are all based on using Office 2003, and am currently working on an automated MM system for school letters, if that helps give an idea of where I'm coming from.