firstly, try checking the number format in the given cells, it may have been
typed as text. if so, changed the number format into 0+00 and type 10000 &
20000 for 100+00 & 200+00, respectively.

since the answer will be in one cell (e.g C1), you can format it as general
E.G.
A1=100+00 <number format as 0+00 meaning 100*100 = 10000 in feet
B1=200+00 <number format as 0+00 meaning 200*100 = 20000 in feet
C1=B1-A1 <number format as general for plan measures as quantity
presentation
meaning 20000-10000= 10000

regards,


"Jupraven" wrote:

I'm trying to calculate the distance between two known Stations (i.e. 100+00
and 200+00) for an easy measure of plan quantities. The Difference between
these two points is 100+00, and the sum is 300+00; obviously (or 100 and 300
respectfully). Ok, so how is this done in Excel to arrive with an answer in
either working number format?
The formatting is a custom type: 000+00, but the cell still references #VALUE.