Function NewWeldStation(OriginalWeldStation As String, AdditionalFeet As Double, Optional StationFormat As String = "#0\+00") As String 'Adds AdditionalFeet to the length equivalent to OriginalWeldStation, then formats the result as a weld station 'If you don't specify a value for StationFormat, you get a value like 758+62 (to be interpreted as 75,862 feet). _ If you want to show inches as well as feet, then you must supply a value for StationFormat. For example, if _ you want to display 758+62.25 (to be interpreted as 75,862' 3") you would use the StationFormat "#0\+00.00" Dim OriginalFeet As Double OriginalFeet = CDbl(Replace(OriginalWeldStation, "+", "")) NewWeldStation = Format(OriginalFeet + AdditionalFeet, StationFormat) End Function
The answer then (in Fortran) was an assembly language routine called when printing.
My guess is you would need a macro to convert the number to text and the insert the + sign and then save in the next column.
Someone here may be able to write such a macro (not my skillset)