Gunn
Measure twice, cut once! Getting Auto Sum to recognize Stationing.
#16
- Group: Member
- Posts: 65
- Joined: 22-February 10
Posted 15 March 2010 - 01:41 PM
Gunn
#17
- Group: Member
- Posts: 1
- Joined: 05-April 12
Posted 05 April 2012 - 04:39 PM
There is a must simpler solution: Just create a custom number format of ###+##.##
To do this just highlight the cells you want and then right click select "Format Cells.."; In the "Format Cell" dialog box the number tab, select custom, then select one format that is close and then click in the "type" field and enter ###+##.##
See attached file screen capture.
You then enter the stationing in stationing feet and it displays the number in the stationing format. You can the do math like auto sum just like the cells are numbers.
To do this just highlight the cells you want and then right click select "Format Cells.."; In the "Format Cell" dialog box the number tab, select custom, then select one format that is close and then click in the "type" field and enter ###+##.##
See attached file screen capture.
You then enter the stationing in stationing feet and it displays the number in the stationing format. You can the do math like auto sum just like the cells are numbers.
