Doctors orders says I must lose weight (and stop drinking :-( ).So my chart readsA) dateB) weight in poundsI wishC) Stones and poundsVoG™, you did this for me before, but that computer is long gone!
=INT(B1/14) & " St " & INT(MOD(B1,14)) & " lb(s)"
Hmm, step by step please! My first entry in B is B3.
so in C3 put VoG's formula, but change B1 to B3...=INT(B3/14) & " St " & INT(MOD(B3,14)) & " lb(s)"then for every weight in lbs entry (B3 downwards), just copy the formula in C3 down, it will automatically adjust to the new row.
Ah, Paste Special, text!Thanks both.
This thread is now locked and can not be replied to.
WPA2 hack: How secure is your Wi-Fi?
Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop
iPhone tips & tricks
Les meilleures tablettes 2017
© Copyright 2017 IDG UK. All Rights Reserved.