Text fraction to fraction format

[brownti via OfficeKB.com]

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?

 

[Ron Rosenfeld]

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