Math functions on non number data?

  • Thread starter Thread starter Dave Jones
  • Start date Start date
D

Dave Jones

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
 
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 said:
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)
Click to expand...
thanks, I'll give that a whirl
Dave
DDP
 
Dave Jones said:
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
Click to expand...

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 your settings.

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
 
Back
Top