Fraction to Decimal

[Michael Dugan]

I got an Excel Spread sheet from one of my suppliers and I'm trying t
use the data to do a bulk import into my online store.

One of the fields is written in "general" format. All the cells in th
column are written as fractions (including the " sign) i.e. 3 3/4"

I used the following function to strip off the "

=CONCATENATE(LEFT(AB2, LEN(AB2)-1))

My problem is no matter how I format the cells, I can't get th
resulting fractional number to appear as a decimal number (I need it t
be in decimal form not "behind the scenes" but visually in the cell s
it imports properly.

I know that this should be simple, but it aint for me!

HELP

 

[Ron Rosenfeld]

I got an Excel Spread sheet from one of my suppliers and I'm trying to
use the data to do a bulk import into my online store.

One of the fields is written in "general" format. All the cells in the
column are written as fractions (including the " sign) i.e. 3 3/4"

I used the following function to strip off the "

=CONCATENATE(LEFT(AB2, LEN(AB2)-1))

My problem is no matter how I format the cells, I can't get the
resulting fractional number to appear as a decimal number (I need it to
be in decimal form not "behind the scenes" but visually in the cell so
it imports properly.

I know that this should be simple, but it aint for me!

HELP!

Replace the " with nothing, then coerce to a numeric value:

=--SUBSTITUTE(AB2,"""","")

The second argument consists of four "

 

[Jyothish]

After you strip, copy entire column and paste only values into anothe
and change the format to general in number tab of format cells