Le 27/04/01 16:08, « Shenoy, Catherine » <[log in to unmask]> a écrit :
> Does anyone know an easy way to format or rescale numeric values. I've got
> numbers in the billions - 9,200,000,000. I'd like to display 9.2. I know
> that I could divide everything by a billion, but I need to do this for a lot
> of files.
>
use a custom format, with a blank. For example: # ##0.0 "".
Note the space between the last 0 and the first quote. ^
Each blank will divide the displayed number by 1000. The quotes are here
just to show that there is one (or more) blank. You may dispense yourself to
use them, but I pity you when you have to find in the format list which is
which...
François Sermier
|