Furkin 08:49 08 May 09

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 09

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 09

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


  Furkin 00:31 10 May 09

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

New iOS 11 release date rumours UK | new features coming to Siri, FaceTime, Messages and Video