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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Richard" wrote in message
...
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