Furkin 08:49 08 May 2009

I'm making a table of my car fuel consumption. I need to convert litres to gallons after each fill-up. The math is fine, & I get the format "=(?/?)" o.k.
I want to use the same format (or similar) in every cell in a column.
Say if I have column A for litres & column B for Gallons - how do I set all of column B to convert the previous cells number, automatically ?
I can do the format to convert A1 to B1, A2 to B2 etc, but only one at a time. I've been playing with the 'stretch' handle hoping to make all of column B into a formatted one.
The problem is, that to convert A1 to B1, one has to actually choose A1 to start with. If I try to use an automated format for A2 to B2, it 'assumes' that I still want to convert A1 - cos that's the figure I first used !

I know i'm making a pigs ear of explaining this, but I know you guys will understand it,,,, just as much as I know you'll have the answer.

thanks for reading this,,,,,,,

  VoG II 09:16 08 May 2009

In B1 enter the formula


Click in B1 then hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as you want.

Now if you look in B2 you should see the formula is


and so on down the column.

  Fermat's Theorem 15:51 09 May 2009

in having a look at the MPG spreadsheet I devised some time ago. click here


  Furkin 00:31 10 May 2009

Cheers again mate - spot on.

Yep - I like it.
I hadn't added the cost values this time, as I used to insert 'em manually.
I'll look up how to add the buttons, to jazz mine up a bit. Thanks


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Creative studio Omnibus' brand identity for We Said Enough, a non-profit against sexual misconduct

What to ask Siri on the HomePod

Meilleurs VPN (2018)