roadway station format

[kc27315]

In my engineering work, I need to display the distance along a roadway curve as follows: 2537.43 feet along the arc from the beginning will be displayed as 23+37.43. The red plus sign is a bit misleading. What 23+37.43 really means is 23*100+37.43, where the black plus sign is the usual addition.

Is there a way to format a cell so that if I type in, say, 913.28 and hit enter, the cell displays "9+13.28" (quotations removed of course)?

[oldchippy]

Just add a single ' before the number then Excel will treat it as text, or Format the cell to TEXT first, then enter your "numbers"

[shg]

Format the cells as #"+"#0.00

[kc27315]

Perfect. Exactly what I was looking for. I want the cells to be user friendly so that others using my spreadsheet won't have to type a ' symbol each time they enter a station.

Thank you both for responding.

kc

[kc27315]

If I enter 46.73, I want it to display as 0+46.73. Is there a way to modify the format #"+"#0.00 to make it work this way for numbers less than 100, also?

kc

[shg]

0"+"#0.00 or 0"+"00.00, as you prefer.

[kc27315]

Sweet! It works great. Thank you so much.

kc

[shg]

You're welcome

Pretty arcane notation ...

[SirExcellency]

The easiest way I've found to accomplish this task of having excel calculate the distance between stationing is to simply cut and paste the following line as your formula:

=SUBSTITUTE(D4,"+","")-SUBSTITUTE(C4,"+","")

Then, change the "D4" part of the formula to whichever is the greater stationing in your table (5174+23) example; and then, change the "C4" to the lesser stationing in your table (5012+12) example; you wish to subtract.

You may also "add" as opposed to subtracting stations by simply changing the "-" to a "+" in front of the second SUBSTITUTE.

Hope this helps as a really much easier way to find the difference between stations, or to add stations.

[alansidman]

@SirExcellency
Welcome to the Forum.
You have responded to a thread that is 16 years old. It is highly unlikely that the OP is still interested in this post. Suggest if you are willing to help here that you concentrate on current posts. I am closing this thread as it is stale.

Alan