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,,
- Nov 21 Wed 2007 20:40
Two little questions
close
全站熱搜
留言列表
發表留言