close

Hi All
Couple of queries I would like a hand with.
1. I know that it is possible to print a draft quality print with the
word draft as a watermark but don't know how to do it?
2. I have a number of figures in the millions which I want to
abbreviate so allow me head the column quot;millionsquot; and the figure to
appear shortened e.g. 10,000,000 = 10 or 2,895,700 = 2.9 etc. Is this
possible without retyping all the figures or updating the formula to
divide by 1,000,000?

Thanks

Claire--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: www.excelforum.com/member.php...oamp;userid=28738
View this thread: www.excelforum.com/showthread...hreadid=532576
quot;weeclairequot; gt; wrote
in message ...
gt;
gt; Hi All
gt; Couple of queries I would like a hand with.
gt; 1. I know that it is possible to print a draft quality print with the
gt; word draft as a watermark but don't know how to do it?See www.xldynamic.com/source/xld.xlFAQ0005.htmlgt; 2. I have a number of figures in the millions which I want to
gt; abbreviate so allow me head the column quot;millionsquot; and the figure to
gt; appear shortened e.g. 10,000,000 = 10 or 2,895,700 = 2.9 etc. Is this
gt; possible without retyping all the figures or updating the formula to
gt; divide by 1,000,000?Format as #.0,,

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()