I am working with old shillings & pence data in Excel which has the format - 1 s. 6 p. (=1 shilling 6 pence) where 12 pence = 1 shilling. It is a list of years, occupations and wages and I need to be able to sort on the currency ascending and also graph the trend of wages. But how do I make Excel understand the value of the shillings and pence currency?
PS, I am not an Excel expert at all! Thanks for any tips.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.