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 - like
this: 0.711299999999999, which are formatted %s. In spreadsheet #2 I
have included the ROUND function to round them all down to 4 decimal
places. Once spreadsheet #2 was populated with the data, I used Save
As to
create spreadsheet #3 and then used copy, paste special, values to
overwrite the formulas with values. Wherever a percentage cell appears
the numbers are to 2 decimal places, like this - 71.13 - which is
exactly how I want this numbers to appear in Word.

However, when I merge the data from spreadsheet #3 I get the very
lengthy
numbers as they appear in the original spreadsheet #1, not the 2
decimal place numbers which I can see in my data file (#3). I even
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 there
are no links in it to any external workbooks; I have re-created my Word
document a few times, re-creating the data file settings each time; I
have shut down both Word and Excel and re-created spreadsheet #3.
Nothing has made any difference.

Any help would be greatly appreciated :)


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=532123

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 Wrote:
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 - like
this: 0.711299999999999, which are formatted %s. In spreadsheet #2 I
have included the ROUND function to round them all down to 4 decimal
places. Once spreadsheet #2 was populated with the data, I used Save
As to
create spreadsheet #3 and then used copy, paste special, values to
overwrite the formulas with values. Wherever a percentage cell appears
the numbers are to 2 decimal places, like this - 71.13 - which is
exactly how I want this numbers to appear in Word.

However, when I merge the data from spreadsheet #3 I get the very
lengthy
numbers as they appear in the original spreadsheet #1, not the 2
decimal place numbers which I can see in my data file (#3). I even
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 there
are no links in it to any external workbooks; I have re-created my Word
document a few times, re-creating the data file settings each time; I
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532123

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

Trish


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=532123