Fraction to Decimal

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!

Thanks Guys,

Both of those solutions worked great for numbers where the value was greater than 1 (i.e. 3 7/8"), but for values less than 1, I got some wacky results.

For example, 3/4" yielded the value of 41337!

Ideas?

Thanks. That worked but it entails searching through the raw data my supplier gave me and manually adding the "0" where it's needed. Not really a good option since there are over 1,200 fields in all.

Is there a more elegant approach?

Thanks Ben!

Not to be pushy, but I get an error in the few cases where there happens to be a whole number in the cell that I'm trying to parse. Any idea how to handle it?

Mike

Awesome! Thanks!