On Sun, 02 Apr 2006 16:12:40 GMT, "blackbox via OfficeKB.com" <u20390@uwe
wrote:

I thought of that but would rather do it in a single cell if possible.
Every day I receive data that isn't in a usable format, I use the MID
function to break it apart.
the data comes in this format 106125. This is actually 106 12.5/32.
I've been displaying it as 25/64 but 12.5/32 is the proper format.
Actually, the ideal format I'd like to display is 106'12.5


You can display 106125 as 106'12.5 by using the custom format:

0'00\.0

However, it will still have a VALUE of 106125

In formulas that rely on the real value, you will have to convert it using the
formula:

=INT(A1/1000)+MOD(A1,1000)/320


--ron