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

use the find and replace command (Edit-Replace) with " in. " in the find
section and nothing in replace section (leave it blank). You will then have
to copy a blank cell and paste special (right click) selecting add.

"Brett" wrote:

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

Sloth I have tried that a couple of combintions and still to no avail. I
guess i am still missing something and not to help I am new at this.

"Sloth" wrote:

use the find and replace command (Edit-Replace) with " in. " in the find
section and nothing in replace section (leave it blank). You will then have
to copy a blank cell and paste special (right click) selecting add.

"Brett" wrote:

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

Thank you Sloth with your help i got it. I when to The tool bar and and hit
Edit Find and there I entered "in" but I could not leave replace blank so I
added 0 with no space wich made the number like this 0.7500 which then the
formatting could do its job to convert to fractions. neat feature. Brett

"Brett" wrote:

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