Word/Excel Integration Problem

[tuph]

This problem is for the Excel/Word integration specialists out there
and is fairly complicated, so please bear with me!

I have a spreadsheet (#2) which contains financial reporting
information gleaned from links to another spreadsheet (#1) and am
trying to use a third version (#3), which has all cells pasted as
values, as the data file for a mail merge in Word.

Spreadsheet #1 contains formulas which return very long decimals - lik
this: 0.711299999999999, which are formatted %s. In spreadsheet #2
have included the ROUND function to round them all down to 4 decima
places. Once spreadsheet #2 was populated with the data, I used Sav
As to
create spreadsheet #3 and then used copy, paste special, values t
overwrite the formulas with values. Wherever a percentage cell appear
the numbers are to 2 decimal places, like this - 71.13 - which i
exactly how I want this numbers to appear in Word.

However, when I merge the data from spreadsheet #3 I get the ver
lengthy
numbers as they appear in the original spreadsheet #1, not the
decimal place numbers which I can see in my data file (#3). I eve
tried
formatting the cells in spreadsheet #3 as text, but that didn't make
any difference.

Before anyone asks, let me state the obvious: I have used the
correct version of the spreadsheet (i.e., #3) as my data file and ther
are no links in it to any external workbooks; I have re-created my Wor
document a few times, re-creating the data file settings each time;
have shut down both Word and Excel and re-created spreadsheet #3.
Nothing has made any difference.

Any help would be greatly appreciated :

 

[Bryan Hessey]

It doesn't matter that you paste-special Values, a computer still has no
true concept of 10c ( or .1 )

Try to format your troublesome fields as =Text(~your formula~,"00.00")

This will give a 73.13 that will retain it's format.

HTH

--

 

[tuph]

Thanks, soooooooo much, Bryan. That's exactly what I needed.

Tris