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

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

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

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 "new" pence?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528855

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

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

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

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

Pete

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

Cheers! 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

"Pete_UK" wrote in message
ups.com...
Well, we still have pints as well, Bernard! I think I'll go for one
now.

Pete

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

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

"Bernard Liengme" wrote:

Cheers! 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

"Pete_UK" wrote in message
ups.com...
Well, we still have pints as well, Bernard! I think I'll go for one
now.

Pete