"weeclaire" wrote
in message ...

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?


See http://www.xldynamic.com/source/xld.xlFAQ0005.html


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?


Format as #.0,,