Converting numbers to station numbering

Copper Contributor

I have numbers in column A below and want to convert them to survey stationing as in column B. Does anyone have any idea how to do this or if it is even possible?

A           B

0           0+00

50         0+50

75         0+75

100       1+00

150       1+50

200       2+00

1000     10+00

1050      10+50



3 Replies


Two options to do this:


As a formula:



or custom cell formatting code: 0+00



Thank you so much for the help. I just tried it and it worked like a charm. So for today at least you are the god of Excel.


Glad I could help. You're welcome!