Formatting without 0's

  • Thread starter Thread starter Mason
  • Start date Start date
M

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
 
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.
 
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




.
Click to expand...
 
Back
Top