View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brett Brett is offline
external usenet poster
 
Posts: 113
Default Converting decmials to factions

Hello I am have trouble with my bill of materials it imports a decmial into
Excel like this .750 in. I have formated the colum to change to factions but
I must go to each individual cell and take the " in. " out to convert to
fractions and i have 3 colums so is this possible to format a colum like
this? Any help would be greatly appreciated~!!!!! Brett