Ron,

Got another question for you.

Your formula,=INT(A2/1000)+MOD(A2,1000)/320, returns 106125 as 106.390625.
Is it possible to format that as 106'12.5?

I've been using =MID(A2,1,3)+(MID(A2,4,3)/320)

Is there any advantage to using one formula or the other?

Your number format works great but I still need it broken down for other
functions.

I would like it displayed as 106'12.5 but recognized by excel as 106.390625.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1