Re: small question about division
- From: "Charles R. Twardy" <charles twardy infotech monash edu au>
- To: Balakrsna <balakrsna neuro-cardiology org>
- Cc: gnumeric-list gnome org
- Subject: Re: small question about division
- Date: Thu, 28 Oct 2004 15:15:23 +1000 (EST)
Hi,
I would start in an empty cell and enter the formula:
B6 / 6.3248e6
Then select that cell and hit "Copy". Highlight it and the next 7 cells
down. (One way is to shift-arrow down 7 times.) Hit "Paste".
Select those 8 cells and the next 3 columns. Hit "Paste"
That should give you a new block of cells which is the old block, divided
by your constant. If you want, paste as values back into the original
block.
B>enclose) the values of which (from B6-E13)
B>should all be divided by 6.3248 10^6.
B>
B>How does one accomplish this ?
--
Charles R. Twardy www.csse.monash.edu.au/~ctwardy
Monash University sarbayes.org
Computer Sci. & Software Eng. +61(3) 9905 5823 (w) 5146 (fax)
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]