Formatting without 0's

[Mason]

I'm linking a calculated amount in Excel to a financial
statement in a Word document. The calculated amount is
0.20, but in the Word document I need the amount to read
as .20 (without the 0 before the decimal point).

It is an ole link from Excel to Word and I would like to
leave the amounts linked so the financial statement is
updated with any changes to the calculated amounts in
Excel. Is this possible?

Thanks
Mason

 

[Bob Phillips]

Mason,

If you mean that you did a paste link in Word, formatting the Excel number
as custom format #.00 seems to do what you want.

 

[Mason]

Yes, that worked. Thank you

-----Original Message-----
Mason,

If you mean that you did a paste link in Word, formatting the Excel number
as custom format #.00 seems to do what you want.

--

HTH

Bob Phillips




.