It appears, after a little experimenting ,that
entering the fraction as a fraction: 0 3/4
or
number formatting the fraction as a fraction
allows the dependent cell to display decimals,
if the dependent cell is formatted as a number.

Jim Cone
San Francisco, USA


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