software

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


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 do
calculations, or convert to quot;newquot; pence?--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528855There 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

quot;Richardquot; gt; wrote in message
...
gt;I would like to be able to enter English pre-decimal currency in an Excel
gt; worksheet - i.e. pounds shillings and pence. Can anyone advise whether
gt; this
gt; is possible and, if so, how to go about it.
gt;
gt; Many thanks
gt;
gt; RICHARD
Well, we still have pints as well, Bernard! I think I'll go for one
now.

PeteCheers! I am going to have a Bodington's with supper ( that's dinner )
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Pete_UKquot; gt; wrote in message ups.com...
gt; Well, we still have pints as well, Bernard! I think I'll go for one
gt; now.
gt;
gt; Pete
gt;
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

quot;Bernard Liengmequot; wrote:

gt; Cheers! I am going to have a Bodington's with supper ( that's dinner )
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Pete_UKquot; gt; wrote in message
gt; ups.com...
gt; gt; Well, we still have pints as well, Bernard! I think I'll go for one
gt; gt; now.
gt; gt;
gt; gt; Pete
gt; gt;
gt;
gt;
gt;