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

paul wrote:
i would try four cells A1 would be for the 12,b1 is =if(c1="","","."),c1 is
where the part fracton goes and d1 is the denominator.In cell e1 try
=A1&B1&C1&"/"&D1.Why isnt 12 and a half 32 equal to 25/64 ?

hth
paul
remove nospam for email addy!

--
Message posted via http://www.officekb.com