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