## Math functions on non number data?

### Math functions on non number data?

is there a way to convert data that is in fraction format to number
format to be able to perform math functions without changing the
original data type?

For instance, change 23 1/2 * 34 3/4 to 23.5*34.75 to come up with
816.625. The result does not need to be in fractional format.

thanks for any assistance,
Dave
DDP

### Math functions on non number data?

I presume you have all of that multiplication in an single cell (otherwise
you would simply be able to multiply whatever two cells contain them)? If
so, try this formula...

=LEFT(A1,FIND("*",A1)-1)*MID(A1,FIND("*",A1)+1,99)

--
Rick (MVP - Excel)

### Math functions on non number data?

thanks, I'll give that a whirl
Dave
DDP

### Math functions on non number data?

"Dave Jones" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

Dave,

Excel can work in fractions and decimals.

Select the area you want to enter your data and then choose Format / Cells /
Fraction.

If you enter a decimal number it will be converted to a fraction according

To enter a fraction directly, type the number, then space, then the
fraction, e.g. 23 1/2.

Add or multiply as you would with any other value, then format your cells as
you would like to have them displayed (Fraction or General).

One useful tip would be to make all your entries and calculations displayed
as fractions in column A, then have B1 = A1, B2 = A2 etc and display column
B as General or Number.

Thomas