1. ## LSD (Excel 2000)

How do I format a column to accept pounds, shillings and pence? I'll want to graph off that column.

I want to try to correlate 19th century freight rates, which are given in LSD in my 1891 San Francisco newspaper, with tonnage or wood/iron construction.

This was supposed to be a simple question to enliven my docent tours. I'm hoping to compare ocean freight around Cape Horn with the cost of rail to New York and ship from there, but it may be getting out of hand.

Thanks,
Pete

2. ## Re: LSD (Excel 2000)

From what you say, I'm not sure that your problem relates to formatting. To make the data entry easier, I would enter the pounds, shillings and pence in 3 separate columns (A, B, and C, say). In column D you could enter a formula such as =A1+B1/20+C1/240. You would then use column D for the graph.
Does this help?

3. ## Re: LSD (Excel 2000)

Pete, Colin's idea is simplest, and to show the numbers in a table in Excel, it's probably easiest to use the following (using his same cells for the source numbers):
=TEXT(A1,CHAR(163)&"#,##0.")&TEXT(B1,"00.")&TEXT(C 1,"00")
rather than a custom number format. (I trashed most of Excel's standard custom formats, so I can't see if there's one that works for LSD.)

4. ## Re: LSD (Excel 2000)

I remember that the way pounds, shillings and pence were generally shown was separated by a forward slash. If you want to display them that way, adjust John's formula to:
=TEXT(A1,CHAR(163)&"#,##0")&"/"&TEXT(B1,"00")&"/"&TEXT(C1,"00")

5. ## Re: LSD (Excel 2000)

Thanks, my memory is going ... last used LSD in 1968 (?) when Aust. went to dismal currency.

6. ## Re: LSD (Excel 2000)

<hr>last used LSD in 1968<hr>
any flashbacks since? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

7. ## Re: LSD (Excel 2000)

I have flashbacks all the time, for example here on the Lounge I keep seeing Elvis and a green lizard.

8. ## Re: LSD (Excel 2000)

you have my vote for today's best post

9. ## Re: LSD (Excel 2000)

It was in 1966. 14th February to be exact.

10. ## Re: LSD (Excel 2000)

Now that I think about it, from associated memories it had to be '66; but wasn't the changeover period about a year?

11. ## Re: LSD (Excel 2000)

14 February was the first day that decimal currency went live. That's the day everyong gathered around anyone who had one of these new-fanfled coins or notes.

LSD was allowed for some time afterwards- perhaps a year, perhaps even more.

The compatible coins remained in circulation long afterwards.

I remember the date because they always mentioned it on a heavily-promoted ad campaign to the tune of "click go the shears".

12. ## Re: LSD (Excel 2000)

... and who could forget the ingeniously named cartoon character used to explain this clever new system to us louts, "Dollar Bill"? It all comes back to me now. And I hold YOU responsible!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•