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 (MVP - Excel)

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)

"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

1. Math.random() and Math.round(Math.random()) and Math.floor(Math.random()*2)

2. Math.random() and Math.round(Math.random()) and Math.floor(Math.random()*2)

3. Math and Non Math Mode Commands

4. Math lesson: large positive number - smaller positive number = positive number

5. {binary search} WAS Non-Ch math, by set-theory non-expert.

6. Basic math Q: how do I make a number-generation function that is b

7. Basic math Q: how do I make a number-generation function that

8. apply a math function to alist of numbers

9. math.h trig functions questions (and some forgotten high school math)

10. extensible math functions: variable number of arguments and class templates

11. how to do math functions on data in a form before saving to SQ

12. how to do math functions on data in a form before saving to SQL 20

13. how to do math functions on data in a form before saving to SQ

14. Filter data in math function

4 post • Page:**1** of **1**