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

@JSwainMetenviro 

Two options to do this:

 

As a formula:

=TEXT(A2:A9,"0+00")

 

or custom cell formatting code: 0+00

@Patrick2788 

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!