OK, here's the next layer of complexity (for me)...given that the resulting
decimal value in the target cell is used in other formulas, a valid number is
required in this target cell as to preclude an error condition in the
dependent formulas. When the source cell (containing the original fraction)
is blank, this otherwise cool fraction-to-decimal formula delivers a
non-numeric value in the target cell ("#VALUE!"). How can I condition the
target cell to defaut to a zero value in this instance?

"Biff" wrote:

Hi!

Assume A1 holds the fractional value. Cell A1 would have to be formatted as
TEXT, otherwise Excel will interpret 3/4 as a date.

=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,255)

Biff

"PDI-AV" wrote in message
...
As a data entry tool in an Excel form, I'd like to convert a numeric
fraction
("3/4") contained in a "source cell" to its decimal equivalent ("0.75")
contained in a corresponding "target cell". The target cell needs to
dynamically react to any changes in the source cell (using formulas and
text-to-column delivers the correct result, but it is not dynamic). Is
this
possible? How?