Solved Format Cell in MS Excel

July 13, 2011 at 22:24:59
Specs: Windows 7, Intel Core2Duo/8GB
 How do I format 2 cells (A1 & B1) so that when the entered data is in "Station" format, I can sum up the 2 cells in a "Number" format in C1?For instance:``` A B C 1 40+49.52 40+97.52 48.0 ``` Thanks,Mike

See More: Format Cell in MS Excel

#1
July 14, 2011 at 13:00:21
 What is "Station" format?How does C1 (48.0) relate to what's in A1 and B1?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
July 14, 2011 at 19:59:26
 In Civil Engineering, Station or STA is assigned by the design engineer on a street, a flood control channel or a storm drain (SD), etc. For instance, for a local street which intersects at a collector street at STA 10+00 and continues to STA 100+00, therefore the distance between the stations is 10,000 - 1,000 = 9,000 LF or the street is 9,000 feet or 1.7 mile long.Even though A1 displays as 40+49.52, its value is 4,049.52and 40+97.52 has a value of 4,097.52. Hence, the distance between the locations in A1 & B1 is 4,097.52 - 4,049.52 = 48 LFI hope that helps!

Report •

#3
July 14, 2011 at 21:03:09