Hi
I currently have a sheet i am working on that has four columns to convert from stones to pounds as excel does not recognise the format as there are 14 pounds in a stone and the data i am pasteing appears as (11-7), What i am having to do is e.g (11st x 14lbs + 7lbs = 161lbs) this is using four cells to do the calculation.
Is there any way i can format the column/cell to recognise when i input data 11-7 to automaticly recognise it and shows 161?
I only need between 8st & 12st.
Thanks
Bookmarks