Two little questions

[weeclaire]

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

 

[Bob Phillips]

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,,