Tuesday, October 2, 2012

Engineering Stationing Custom Format

This is going to be a short but useful one for those who need to work with Stations.

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 









1 comment: