Forum Discussion
Converting numbers to station numbering
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
Two options to do this:
As a formula:
=TEXT(A2:A9,"0+00")or custom cell formatting code: 0+00
Patrick,
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!
