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...
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!