Issue (2 parts): I type in numbers that have a space such as 22 56. Sometimes there may be a decimal such as 22 56.7 and sometimes there will be a + sign such as 22 56.7+ (the + sign represents .5 and I need the cell to recognize this so that when I type in 22 56.7, it converts it into 22 57.2 (+ added as a value of .5 and the + sign should now be gone from the cell).
Part 2: Assuming the + is converted I need the value I type in to be crunched according to a certain formula. If I type in 22 56.4 (or whatever the number is), I need it to perform: 56.4/32+22
In this part, the + sign should not convert to a .5 - it needs to divide 56.4 by 32 and then add 22 to that. Make sense?
What I have tried (but don't know enough to get them to work)
1. A Constant in VBA?
2. "For each" variable?
Any thoughts?
Part 2: Assuming the + is converted I need the value I type in to be crunched according to a certain formula. If I type in 22 56.4 (or whatever the number is), I need it to perform: 56.4/32+22
In this part, the + sign should not convert to a .5 - it needs to divide 56.4 by 32 and then add 22 to that. Make sense?
What I have tried (but don't know enough to get them to work)
1. A Constant in VBA?
2. "For each" variable?
Any thoughts?