Forum Discussion
Assign numeric value to text cell
Hello, I'm making a pricing spreadhseet and I need to assign a numeric value to a text a cell which can be selected from a multiple option list that lies in another sheet in the same document. Th...
Hello I think you may be able to help me
I have a staff rota and we use E (early shift) and L (late shift) i want the colobm at the side to add the hours together. So I want to hide the numerical value of those letters up. So for example L=10hours Lx5=50hours? mathetes
I may be able to help, and there are others here on this site who also may be able to help. But in order for anybody to help, you'll need to give a more complete picture (or post a copy of your actual workbook) of what it is that you're working with. And might I suggest that you start a new thread. It isn't really clear that this builds on what preceded it in this thread.