excel cell in #+## format 1

[youngEIT]

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.

 

[cvg]

go to custom format and enter the following:
###+##.00

 

[ACtrafficengr]

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