Two little questions

W

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
 
B

Bob Phillips

weeclaire said:
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?
Click to expand...


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?
Click to expand...


Format as #.0,,
 
Top