Extract numerator from fraction
< I thought I could do this by converting text to columns with the "/" as a delimiter
You were on the right track.
This is easiest with helper columns, but can be done in one formula:
=RIGHT(TEXT(A1,"? ?/?"),LEN(TEXT(A1,"? ?/?"))-FIND("/",TEXT(A1,"? ?/?")))
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"tf" wrote in message ...
|I have a column of decimal values in an Excel 2003. I have converted the
| values to fractions using the "format cell" function and would like to
| extract the numerator values from the fractions. I thought I could do this
| by converting text to columns with the "/" as a delimiter, such that the
| numerator and denominator values would be returned in separate columns. The
| problem is that even though my values show as a fraction, they are still read
| as decimals by Excel and the text to columns won't work. I've tried using
| the "paste special" function to replace the decimals with the fraction
| values, but that did not work either.
|
| Any ideas on how to get Excel to read the values as fractions so that I can
| use the text to columns function; or another method that will allow me to
| extract the numerator values? (I don't have a common denominator, so I can't
| use the dollar functions)
|
| Thanks!
|