Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Jun 2001
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    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. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    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.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    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. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: LSD (Excel 2000)

    Thanks, my memory is going ... last used LSD in 1968 (?) when Aust. went to dismal currency.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    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>
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: LSD (Excel 2000)

    I have flashbacks all the time, for example here on the Lounge I keep seeing Elvis and a green lizard.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LSD (Excel 2000)

    you have my vote for today's best post

  9. #9
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: LSD (Excel 2000)

    Your memory certainly is going.

    It was in 1966. 14th February to be exact.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    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?
    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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".
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    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!
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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