How to enter pre-decimal pounds shillings pence in Excel workshee

[Guest]

I would like to be able to enter English pre-decimal currency in an Excel
worksheet - i.e. pounds shillings and pence. Can anyone advise whether this
is possible and, if so, how to go about it.

Many thanks

RICHARD

 

[daddylonglegs]

I think it depends what you want to do with it.

Do you want to input just for display purposes or do you want to d
calculations, or convert to "new" pence

 

[Bernard Liengme]

There is no way to put 3-4-6 in a single cell to mean £3, 4s and 6p, and be
able to do arithmetic on the numbers. You will need to use three columns
Put some pound values in A1:A4, some shilling values in B1:B4 and pence
values in C1:C4
Sum the pennies with =MOD(SUM(C1:C4),12)
Sum the shillings with =MOD(SUM(B1:B4)+INT(SUM(C1:C4)/12),20)
Sum the pounds with =SUM(A1:A4)+INT(SUM(B1:B4)/20)
Other arithmetic ops can be done similarly.
If you have lots to do, think about writing a UDF.
I wonder if MS would have had such a feature if Office had predated
metrification.
What memories all this brings back - I can still feel Miss Morrison's hand
slapping my head when I got a sum wrong! Wonder why the UK still has miles;
in Canada we went the whole hog.
best wishes

 

[Pete_UK]

Well, we still have pints as well, Bernard! I think I'll go for one
now.

Pete

 

[Bernard Liengme]

Cheers! I am going to have a Bodington's with supper ( that's dinner )

 

[Guest]

Many thanks, Bernard, for your response. We'll give that a try. Since I'm in
Western Australia I'll drown my sorrows in Swan Lager if I can't get it to
work!

Richard