To keep values as numbers and display them as Stations we will need to create a custom format.
Select the cells you want to display as stations, rightclick and choose format.
Under the Number Tab choose Custom at the bottom.
Input this"##+#0.00" as the Type:
Now our raw number of 8676.70 in N3 is displayed as 86+76.70
Thank you. God Bless
ReplyDelete