Formula to convert long decimals into fractions

[ctinmotion]

I have a worksheet housing long decimal numbers as a specific lengths. I need to convert the decimals to fractions.

Example (in inches):

<TABLE style="WIDTH: 95pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=127 border=0><COLGROUP><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4644" width=127><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 95pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=127 height=17> 00002.8346</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 00003.1496</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 00003.1496</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 00003.3464</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 00003.3464</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17> 00003.3464</TD></TR></TBODY></TABLE>

I need to convert each of these to fractions to represent their size in inches. I need the formatted output to be specific though. I need it to read as

Example:

00001.25 = 1-1/4" (dash included)

Is there a script that can do that or a specific function maybe? I'm stumped!

 

[Special-K99]

You could use the TEXT function

=TEXT(A1,"# ??/???")

to convert to fraction

You'll probably then need a combination of FIND, LEFT, RIGHT, SUBSTITUTE to locates the spaces and replace with the required hyphen

 

[Kelbo]

Hi,

Welcome to the board.

You don't say which version of excel you are using, but in ver 2007 you can cormat as fractions!

If you format to 32ths then the formatting appears as 3 5/32.

Goto custom formatting and change to: 0"-"??/32.

It appears that you can also use: 0"-"??/128

Kelbo

 

[ctinmotion]

Thank you both! I am using 2007 so I will try the custom formatting to see if that works. My only problem I had was with the leading zero's. I will try it and see if it works. Thanks again!