View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brownti via OfficeKB.com brownti via OfficeKB.com is offline
external usenet poster
 
Posts: 103
Default 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