View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
weeclaire
 
Posts: n/a
Default Two little questions


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 "millions" 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: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=532576