Forum Discussion
JSwainMetenviro
Mar 01, 2024Copper Contributor
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...
Patrick2788
Mar 01, 2024Silver Contributor
Two options to do this:
As a formula:
=TEXT(A2:A9,"0+00")
or custom cell formatting code: 0+00
JSwainMetenviro
Mar 04, 2024Copper Contributor
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.
- Patrick2788Mar 04, 2024Silver ContributorGlad I could help. You're welcome!