Text fraction to fraction format
 

I have hundreds of entries that are formated as text cells. the values in
these text cells are sizes such as 2 1/4 i have broken this up to two cells
one with a 2 and one with 1/4 but they are still formated as text cells. i
want to make the fraction formated as a fraction but it wont change. (I want
to convert all fractions to 16ths). Any thoughts on how i can do this?

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

Text fraction to fraction format
 

On Fri, 01 Feb 2008 14:13:34 GMT, "brownti via OfficeKB.com" <u31540@uwe
wrote:

I have hundreds of entries that are formated as text cells. the values in
these text cells are sizes such as 2 1/4 i have broken this up to two cells
one with a 2 and one with 1/4 but they are still formated as text cells. i
want to make the fraction formated as a fraction but it wont change. (I want
to convert all fractions to 16ths). Any thoughts on how i can do this?

Working from your original cell, containing, for example:

A1: 2 1/4

Use:

B1: =ROUND(A1*16,0)/16

and format as fraction: as sixteenths


--ron