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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Failing IF Statement 2
Dollar amounts aren't merging from Excel into a Word document... 3
Access #Error & Excel Pivot 0
Merge Docunent 2
Conditional function row formatting based on columns values being 2
Excel to Word Macro 1
Calcution with two conditon 7
Pivot table, IF function, calculated item versus calculated field 1

Back
Top