Math functions on non number data?

Math functions on non number data?

Post by Dave Jone » Sun, 21 Sep 2008 05:05:52


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?

Post by Rick Roths » Sun, 21 Sep 2008 05:25:50

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?

Post by Dave Jone » Sun, 21 Sep 2008 06:29:19


thanks, I'll give that a whirl
Dave
DDP
 
 
 

Math functions on non number data?

Post by Thomas Har » Mon, 22 Sep 2008 22:08:27


"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 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