Formating Cells

[effendrew-google]

Is there any way to format the cells to treat info as Distance (10' 3")
? i know there is accounting and date.....

Thanks

 

[JE McGimpsey]

Is there any way to format the cells to treat info as Distance (10' 3")
? i know there is accounting and date.....

There is no format that will do it. Depending on what you're trying to
do, you can use formulas or User Defined Functions. Search the archives

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

for a solution to a similar problem.

You can also find some good stuff at David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/fractex1.htm