can anyone tell me how i can format a cell (with number) to a #+## format? i have alignment stationing in Land desktop which are 19+35.88, 4+56.63 etc. i want to type 1935.88 in excel and want excel to display 19+35.88, so that i can still run formulas in this cell. any help is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel cell in #+## format 1
- Thread starter youngEIT
- Start date
-
1
- #2
ACtrafficengr
Civil/Environmental
Rats, cvg! You beat me to it!
Achhibber, from the menu go to /format/cells, click the number tab, and 'custom' is at the bottom of the list.
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928
"I'm searching for the questions, so my answers will make sense." - Stephen Brust
Achhibber, from the menu go to /format/cells, click the number tab, and 'custom' is at the bottom of the list.
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928
"I'm searching for the questions, so my answers will make sense." - Stephen Brust
- Status
